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 |
---|---|---|---|---|---|---|---|
1783324 | 1783324 | 2021-10-04 | Marion | South Carolina | 45067 | 5304 | 133 |
1783459 | 1783459 | 2021-10-04 | Marion | Tennessee | 47115 | 5576 | 52 |
1783654 | 1783654 | 2021-10-04 | Marion | Texas | 48315 | 1125 | 44 |
1783997 | 1783997 | 2021-10-04 | Marion | West Virginia | 54049 | 7119 | 76 |
1777671 | 1777671 | 2021-10-03 | Marion | Alabama | 1093 | 4873 | 125 |
1777780 | 1777780 | 2021-10-03 | Marion | Arkansas | 5089 | 2091 | 55 |
1777988 | 1777988 | 2021-10-03 | Marion | Florida | 12083 | 55600 | 1659 |
1778111 | 1778111 | 2021-10-03 | Marion | Georgia | 13197 | 936 | 34 |
1778284 | 1778284 | 2021-10-03 | Marion | Illinois | 17121 | 6691 | 144 |
1778378 | 1778378 | 2021-10-03 | Marion | Indiana | 18097 | 131414 | 2102 |
1778484 | 1778484 | 2021-10-03 | Marion | Iowa | 19125 | 4768 | 86 |
1778578 | 1778578 | 2021-10-03 | Marion | Kansas | 20115 | 1464 | 27 |
1778701 | 1778701 | 2021-10-03 | Marion | Kentucky | 21155 | 3713 | 40 |
1779086 | 1779086 | 2021-10-03 | Marion | Mississippi | 28091 | 4138 | 104 |
1779187 | 1779187 | 2021-10-03 | Marion | Missouri | 29127 | 5070 | 58 |
1779738 | 1779738 | 2021-10-03 | Marion | Ohio | 39101 | 11245 | 153 |
1779878 | 1779878 | 2021-10-03 | Marion | Oregon | 41047 | 34416 | 411 |
1780075 | 1780075 | 2021-10-03 | Marion | South Carolina | 45067 | 5244 | 131 |
1780210 | 1780210 | 2021-10-03 | Marion | Tennessee | 47115 | 5546 | 52 |
1780405 | 1780405 | 2021-10-03 | Marion | Texas | 48315 | 1125 | 44 |
1780748 | 1780748 | 2021-10-03 | Marion | West Virginia | 54049 | 7073 | 76 |
1774421 | 1774421 | 2021-10-02 | Marion | Alabama | 1093 | 4868 | 125 |
1774530 | 1774530 | 2021-10-02 | Marion | Arkansas | 5089 | 2089 | 55 |
1774738 | 1774738 | 2021-10-02 | Marion | Florida | 12083 | 55600 | 1609 |
1774861 | 1774861 | 2021-10-02 | Marion | Georgia | 13197 | 936 | 34 |
1775034 | 1775034 | 2021-10-02 | Marion | Illinois | 17121 | 6691 | 144 |
1775128 | 1775128 | 2021-10-02 | Marion | Indiana | 18097 | 131414 | 2102 |
1775234 | 1775234 | 2021-10-02 | Marion | Iowa | 19125 | 4768 | 86 |
1775328 | 1775328 | 2021-10-02 | Marion | Kansas | 20115 | 1464 | 27 |
1775451 | 1775451 | 2021-10-02 | Marion | Kentucky | 21155 | 3713 | 40 |
1775836 | 1775836 | 2021-10-02 | Marion | Mississippi | 28091 | 4138 | 104 |
1775937 | 1775937 | 2021-10-02 | Marion | Missouri | 29127 | 5069 | 58 |
1776488 | 1776488 | 2021-10-02 | Marion | Ohio | 39101 | 11230 | 153 |
1776628 | 1776628 | 2021-10-02 | Marion | Oregon | 41047 | 34416 | 411 |
1776825 | 1776825 | 2021-10-02 | Marion | South Carolina | 45067 | 5244 | 131 |
1776960 | 1776960 | 2021-10-02 | Marion | Tennessee | 47115 | 5546 | 52 |
1777155 | 1777155 | 2021-10-02 | Marion | Texas | 48315 | 1125 | 44 |
1777498 | 1777498 | 2021-10-02 | Marion | West Virginia | 54049 | 7006 | 76 |
1771171 | 1771171 | 2021-10-01 | Marion | Alabama | 1093 | 4861 | 124 |
1771280 | 1771280 | 2021-10-01 | Marion | Arkansas | 5089 | 2086 | 55 |
1771488 | 1771488 | 2021-10-01 | Marion | Florida | 12083 | 55600 | 1609 |
1771611 | 1771611 | 2021-10-01 | Marion | Georgia | 13197 | 936 | 34 |
1771784 | 1771784 | 2021-10-01 | Marion | Illinois | 17121 | 6691 | 144 |
1771878 | 1771878 | 2021-10-01 | Marion | Indiana | 18097 | 131414 | 2102 |
1771984 | 1771984 | 2021-10-01 | Marion | Iowa | 19125 | 4768 | 86 |
1772078 | 1772078 | 2021-10-01 | Marion | Kansas | 20115 | 1464 | 27 |
1772201 | 1772201 | 2021-10-01 | Marion | Kentucky | 21155 | 3713 | 40 |
1772586 | 1772586 | 2021-10-01 | Marion | Mississippi | 28091 | 4138 | 104 |
1772687 | 1772687 | 2021-10-01 | Marion | Missouri | 29127 | 5065 | 58 |
1773238 | 1773238 | 2021-10-01 | Marion | Ohio | 39101 | 11189 | 153 |
1773378 | 1773378 | 2021-10-01 | Marion | Oregon | 41047 | 34416 | 411 |
1773575 | 1773575 | 2021-10-01 | Marion | South Carolina | 45067 | 5244 | 131 |
1773710 | 1773710 | 2021-10-01 | Marion | Tennessee | 47115 | 5546 | 52 |
1773905 | 1773905 | 2021-10-01 | Marion | Texas | 48315 | 1118 | 42 |
1774248 | 1774248 | 2021-10-01 | Marion | West Virginia | 54049 | 6961 | 76 |
1767922 | 1767922 | 2021-09-30 | Marion | Alabama | 1093 | 4853 | 123 |
1768031 | 1768031 | 2021-09-30 | Marion | Arkansas | 5089 | 2075 | 55 |
1768239 | 1768239 | 2021-09-30 | Marion | Florida | 12083 | 54999 | 1609 |
1768362 | 1768362 | 2021-09-30 | Marion | Georgia | 13197 | 932 | 33 |
1768535 | 1768535 | 2021-09-30 | Marion | Illinois | 17121 | 6663 | 144 |
1768629 | 1768629 | 2021-09-30 | Marion | Indiana | 18097 | 131082 | 2100 |
1768735 | 1768735 | 2021-09-30 | Marion | Iowa | 19125 | 4768 | 86 |
1768829 | 1768829 | 2021-09-30 | Marion | Kansas | 20115 | 1440 | 27 |
1768952 | 1768952 | 2021-09-30 | Marion | Kentucky | 21155 | 3699 | 40 |
1769337 | 1769337 | 2021-09-30 | Marion | Mississippi | 28091 | 4131 | 104 |
1769438 | 1769438 | 2021-09-30 | Marion | Missouri | 29127 | 5057 | 58 |
1769988 | 1769988 | 2021-09-30 | Marion | Ohio | 39101 | 11133 | 152 |
1770128 | 1770128 | 2021-09-30 | Marion | Oregon | 41047 | 34255 | 410 |
1770325 | 1770325 | 2021-09-30 | Marion | South Carolina | 45067 | 5219 | 131 |
1770460 | 1770460 | 2021-09-30 | Marion | Tennessee | 47115 | 5528 | 52 |
1770655 | 1770655 | 2021-09-30 | Marion | Texas | 48315 | 1114 | 41 |
1770998 | 1770998 | 2021-09-30 | Marion | West Virginia | 54049 | 6891 | 74 |
1764673 | 1764673 | 2021-09-29 | Marion | Alabama | 1093 | 4840 | 122 |
1764782 | 1764782 | 2021-09-29 | Marion | Arkansas | 5089 | 2070 | 55 |
1764990 | 1764990 | 2021-09-29 | Marion | Florida | 12083 | 54999 | 1609 |
1765113 | 1765113 | 2021-09-29 | Marion | Georgia | 13197 | 931 | 33 |
1765286 | 1765286 | 2021-09-29 | Marion | Illinois | 17121 | 6648 | 144 |
1765380 | 1765380 | 2021-09-29 | Marion | Indiana | 18097 | 130646 | 2095 |
1765486 | 1765486 | 2021-09-29 | Marion | Iowa | 19125 | 4768 | 86 |
1765580 | 1765580 | 2021-09-29 | Marion | Kansas | 20115 | 1440 | 27 |
1765703 | 1765703 | 2021-09-29 | Marion | Kentucky | 21155 | 3683 | 40 |
1766088 | 1766088 | 2021-09-29 | Marion | Mississippi | 28091 | 4124 | 104 |
1766189 | 1766189 | 2021-09-29 | Marion | Missouri | 29127 | 5052 | 58 |
1766739 | 1766739 | 2021-09-29 | Marion | Ohio | 39101 | 11076 | 152 |
1766879 | 1766879 | 2021-09-29 | Marion | Oregon | 41047 | 34089 | 406 |
1767076 | 1767076 | 2021-09-29 | Marion | South Carolina | 45067 | 5185 | 130 |
1767211 | 1767211 | 2021-09-29 | Marion | Tennessee | 47115 | 5510 | 52 |
1767406 | 1767406 | 2021-09-29 | Marion | Texas | 48315 | 1109 | 41 |
1767749 | 1767749 | 2021-09-29 | Marion | West Virginia | 54049 | 6819 | 72 |
1761424 | 1761424 | 2021-09-28 | Marion | Alabama | 1093 | 4830 | 121 |
1761533 | 1761533 | 2021-09-28 | Marion | Arkansas | 5089 | 2066 | 55 |
1761741 | 1761741 | 2021-09-28 | Marion | Florida | 12083 | 54999 | 1609 |
1761864 | 1761864 | 2021-09-28 | Marion | Georgia | 13197 | 929 | 32 |
1762037 | 1762037 | 2021-09-28 | Marion | Illinois | 17121 | 6634 | 144 |
1762131 | 1762131 | 2021-09-28 | Marion | Indiana | 18097 | 130382 | 2087 |
1762237 | 1762237 | 2021-09-28 | Marion | Iowa | 19125 | 4643 | 86 |
1762331 | 1762331 | 2021-09-28 | Marion | Kansas | 20115 | 1413 | 26 |
1762454 | 1762454 | 2021-09-28 | Marion | Kentucky | 21155 | 3663 | 40 |
1762839 | 1762839 | 2021-09-28 | Marion | Mississippi | 28091 | 4119 | 104 |
1762940 | 1762940 | 2021-09-28 | Marion | Missouri | 29127 | 5044 | 58 |
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);