ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,212 rows where county = "Marion" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534784 | 534784 | 2020-09-15 | Marion | Florida | 12083 | 9217 | 253 |
534907 | 534907 | 2020-09-15 | Marion | Georgia | 13197 | 181 | 8 |
535078 | 535078 | 2020-09-15 | Marion | Illinois | 17121 | 441 | 0 |
535172 | 535172 | 2020-09-15 | Marion | Indiana | 18097 | 20363 | 807 |
535278 | 535278 | 2020-09-15 | Marion | Iowa | 19125 | 674 | 3 |
535372 | 535372 | 2020-09-15 | Marion | Kansas | 20115 | 85 | 1 |
535495 | 535495 | 2020-09-15 | Marion | Kentucky | 21155 | 210 | 8 |
535879 | 535879 | 2020-09-15 | Marion | Mississippi | 28091 | 824 | 31 |
535980 | 535980 | 2020-09-15 | Marion | Missouri | 29127 | 610 | 7 |
536526 | 536526 | 2020-09-15 | Marion | Ohio | 39101 | 3046 | 47 |
536665 | 536665 | 2020-09-15 | Marion | Oregon | 41047 | 4287 | 88 |
536861 | 536861 | 2020-09-15 | Marion | South Carolina | 45067 | 783 | 20 |
536996 | 536996 | 2020-09-15 | Marion | Tennessee | 47115 | 460 | 7 |
537188 | 537188 | 2020-09-15 | Marion | Texas | 48315 | 147 | 13 |
537532 | 537532 | 2020-09-15 | Marion | West Virginia | 54049 | 246 | 3 |
531235 | 531235 | 2020-09-14 | Marion | Alabama | 1093 | 892 | 28 |
531342 | 531342 | 2020-09-14 | Marion | Arkansas | 5089 | 62 | 0 |
531549 | 531549 | 2020-09-14 | Marion | Florida | 12083 | 9165 | 248 |
531672 | 531672 | 2020-09-14 | Marion | Georgia | 13197 | 180 | 7 |
531843 | 531843 | 2020-09-14 | Marion | Illinois | 17121 | 436 | 0 |
531937 | 531937 | 2020-09-14 | Marion | Indiana | 18097 | 20314 | 806 |
532043 | 532043 | 2020-09-14 | Marion | Iowa | 19125 | 666 | 3 |
532137 | 532137 | 2020-09-14 | Marion | Kansas | 20115 | 85 | 1 |
532260 | 532260 | 2020-09-14 | Marion | Kentucky | 21155 | 209 | 8 |
532644 | 532644 | 2020-09-14 | Marion | Mississippi | 28091 | 823 | 30 |
532745 | 532745 | 2020-09-14 | Marion | Missouri | 29127 | 604 | 7 |
533290 | 533290 | 2020-09-14 | Marion | Ohio | 39101 | 3040 | 46 |
533429 | 533429 | 2020-09-14 | Marion | Oregon | 41047 | 4258 | 87 |
533625 | 533625 | 2020-09-14 | Marion | South Carolina | 45067 | 772 | 20 |
533760 | 533760 | 2020-09-14 | Marion | Tennessee | 47115 | 452 | 7 |
533952 | 533952 | 2020-09-14 | Marion | Texas | 48315 | 147 | 13 |
534296 | 534296 | 2020-09-14 | Marion | West Virginia | 54049 | 244 | 3 |
527998 | 527998 | 2020-09-13 | Marion | Alabama | 1093 | 891 | 28 |
528105 | 528105 | 2020-09-13 | Marion | Arkansas | 5089 | 60 | 0 |
528312 | 528312 | 2020-09-13 | Marion | Florida | 12083 | 9146 | 243 |
528435 | 528435 | 2020-09-13 | Marion | Georgia | 13197 | 178 | 7 |
528606 | 528606 | 2020-09-13 | Marion | Illinois | 17121 | 427 | 0 |
528700 | 528700 | 2020-09-13 | Marion | Indiana | 18097 | 20233 | 805 |
528806 | 528806 | 2020-09-13 | Marion | Iowa | 19125 | 660 | 3 |
528900 | 528900 | 2020-09-13 | Marion | Kansas | 20115 | 84 | 1 |
529023 | 529023 | 2020-09-13 | Marion | Kentucky | 21155 | 205 | 7 |
529408 | 529408 | 2020-09-13 | Marion | Mississippi | 28091 | 823 | 29 |
529509 | 529509 | 2020-09-13 | Marion | Missouri | 29127 | 595 | 7 |
530055 | 530055 | 2020-09-13 | Marion | Ohio | 39101 | 3034 | 46 |
530194 | 530194 | 2020-09-13 | Marion | Oregon | 41047 | 4248 | 87 |
530390 | 530390 | 2020-09-13 | Marion | South Carolina | 45067 | 768 | 19 |
530525 | 530525 | 2020-09-13 | Marion | Tennessee | 47115 | 434 | 7 |
530717 | 530717 | 2020-09-13 | Marion | Texas | 48315 | 147 | 13 |
531061 | 531061 | 2020-09-13 | Marion | West Virginia | 54049 | 243 | 3 |
524762 | 524762 | 2020-09-12 | Marion | Alabama | 1093 | 883 | 28 |
524869 | 524869 | 2020-09-12 | Marion | Arkansas | 5089 | 60 | 0 |
525076 | 525076 | 2020-09-12 | Marion | Florida | 12083 | 9108 | 237 |
525199 | 525199 | 2020-09-12 | Marion | Georgia | 13197 | 178 | 7 |
525370 | 525370 | 2020-09-12 | Marion | Illinois | 17121 | 414 | 0 |
525464 | 525464 | 2020-09-12 | Marion | Indiana | 18097 | 19822 | 805 |
525570 | 525570 | 2020-09-12 | Marion | Iowa | 19125 | 652 | 3 |
525664 | 525664 | 2020-09-12 | Marion | Kansas | 20115 | 84 | 1 |
525787 | 525787 | 2020-09-12 | Marion | Kentucky | 21155 | 203 | 7 |
526172 | 526172 | 2020-09-12 | Marion | Mississippi | 28091 | 820 | 29 |
526273 | 526273 | 2020-09-12 | Marion | Missouri | 29127 | 583 | 7 |
526818 | 526818 | 2020-09-12 | Marion | Ohio | 39101 | 3034 | 46 |
526957 | 526957 | 2020-09-12 | Marion | Oregon | 41047 | 4222 | 85 |
527153 | 527153 | 2020-09-12 | Marion | South Carolina | 45067 | 762 | 19 |
527288 | 527288 | 2020-09-12 | Marion | Tennessee | 47115 | 430 | 7 |
527480 | 527480 | 2020-09-12 | Marion | Texas | 48315 | 147 | 13 |
527824 | 527824 | 2020-09-12 | Marion | West Virginia | 54049 | 240 | 3 |
521526 | 521526 | 2020-09-11 | Marion | Alabama | 1093 | 876 | 28 |
521633 | 521633 | 2020-09-11 | Marion | Arkansas | 5089 | 57 | 0 |
521840 | 521840 | 2020-09-11 | Marion | Florida | 12083 | 9043 | 235 |
521963 | 521963 | 2020-09-11 | Marion | Georgia | 13197 | 178 | 7 |
522134 | 522134 | 2020-09-11 | Marion | Illinois | 17121 | 403 | 0 |
522228 | 522228 | 2020-09-11 | Marion | Indiana | 18097 | 19717 | 805 |
522334 | 522334 | 2020-09-11 | Marion | Iowa | 19125 | 643 | 3 |
522428 | 522428 | 2020-09-11 | Marion | Kansas | 20115 | 84 | 1 |
522551 | 522551 | 2020-09-11 | Marion | Kentucky | 21155 | 203 | 7 |
522936 | 522936 | 2020-09-11 | Marion | Mississippi | 28091 | 819 | 28 |
523037 | 523037 | 2020-09-11 | Marion | Missouri | 29127 | 575 | 7 |
523582 | 523582 | 2020-09-11 | Marion | Ohio | 39101 | 3031 | 46 |
523721 | 523721 | 2020-09-11 | Marion | Oregon | 41047 | 4174 | 85 |
523917 | 523917 | 2020-09-11 | Marion | South Carolina | 45067 | 756 | 19 |
524052 | 524052 | 2020-09-11 | Marion | Tennessee | 47115 | 425 | 7 |
524244 | 524244 | 2020-09-11 | Marion | Texas | 48315 | 147 | 13 |
524588 | 524588 | 2020-09-11 | Marion | West Virginia | 54049 | 235 | 2 |
518289 | 518289 | 2020-09-10 | Marion | Alabama | 1093 | 868 | 28 |
518396 | 518396 | 2020-09-10 | Marion | Arkansas | 5089 | 57 | 0 |
518603 | 518603 | 2020-09-10 | Marion | Florida | 12083 | 8967 | 235 |
518726 | 518726 | 2020-09-10 | Marion | Georgia | 13197 | 178 | 6 |
518897 | 518897 | 2020-09-10 | Marion | Illinois | 17121 | 387 | 0 |
518991 | 518991 | 2020-09-10 | Marion | Indiana | 18097 | 19641 | 804 |
519097 | 519097 | 2020-09-10 | Marion | Iowa | 19125 | 622 | 3 |
519191 | 519191 | 2020-09-10 | Marion | Kansas | 20115 | 84 | 1 |
519314 | 519314 | 2020-09-10 | Marion | Kentucky | 21155 | 200 | 7 |
519699 | 519699 | 2020-09-10 | Marion | Mississippi | 28091 | 809 | 28 |
519800 | 519800 | 2020-09-10 | Marion | Missouri | 29127 | 574 | 7 |
520346 | 520346 | 2020-09-10 | Marion | Ohio | 39101 | 3030 | 46 |
520485 | 520485 | 2020-09-10 | Marion | Oregon | 41047 | 4141 | 85 |
520681 | 520681 | 2020-09-10 | Marion | South Carolina | 45067 | 752 | 18 |
520816 | 520816 | 2020-09-10 | Marion | Tennessee | 47115 | 413 | 7 |
521008 | 521008 | 2020-09-10 | Marion | Texas | 48315 | 147 | 13 |
521352 | 521352 | 2020-09-10 | Marion | West Virginia | 54049 | 234 | 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);