ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

9,642 rows where county = "Marion" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Marion · 9,642 ✖
Link rowid date ▲ county state fips cases deaths
1816660 1816660 2021-10-15 Marion Alabama 1093 4952 126
1816769 1816769 2021-10-15 Marion Arkansas 5089 2114 57
1816977 1816977 2021-10-15 Marion Florida 12083 56318 1690
1817100 1817100 2021-10-15 Marion Georgia 13197 956 36
1817273 1817273 2021-10-15 Marion Illinois 17121 6871 149
1817367 1817367 2021-10-15 Marion Indiana 18097 134544 2181
1817473 1817473 2021-10-15 Marion Iowa 19125 5000 91
1817567 1817567 2021-10-15 Marion Kansas 20115 1549 27
1817690 1817690 2021-10-15 Marion Kentucky 21155 3824 43
1818075 1818075 2021-10-15 Marion Mississippi 28091 4216 107
1818176 1818176 2021-10-15 Marion Missouri 29127 5125 63
1818726 1818726 2021-10-15 Marion Ohio 39101 11742 175
1818866 1818866 2021-10-15 Marion Oregon 41047 36055 444
1819063 1819063 2021-10-15 Marion South Carolina 45067 5384 136
1819198 1819198 2021-10-15 Marion Tennessee 47115 5694 52
1819393 1819393 2021-10-15 Marion Texas 48315 1159 49
1819736 1819736 2021-10-15 Marion West Virginia 54049 7659 96
1813412 1813412 2021-10-14 Marion Alabama 1093 4942 126
1813521 1813521 2021-10-14 Marion Arkansas 5089 2113 57
1813729 1813729 2021-10-14 Marion Florida 12083 56016 1659
1813852 1813852 2021-10-14 Marion Georgia 13197 955 35
1814025 1814025 2021-10-14 Marion Illinois 17121 6857 149
1814119 1814119 2021-10-14 Marion Indiana 18097 134312 2177
1814225 1814225 2021-10-14 Marion Iowa 19125 5000 91
1814319 1814319 2021-10-14 Marion Kansas 20115 1537 27
1814442 1814442 2021-10-14 Marion Kentucky 21155 3819 43
1814826 1814826 2021-10-14 Marion Mississippi 28091 4206 107
1814927 1814927 2021-10-14 Marion Missouri 29127 5119 63
1815477 1815477 2021-10-14 Marion Ohio 39101 11708 169
1815617 1815617 2021-10-14 Marion Oregon 41047 35931 442
1815814 1815814 2021-10-14 Marion South Carolina 45067 5383 135
1815949 1815949 2021-10-14 Marion Tennessee 47115 5683 52
1816144 1816144 2021-10-14 Marion Texas 48315 1158 49
1816487 1816487 2021-10-14 Marion West Virginia 54049 7608 93
1810163 1810163 2021-10-13 Marion Alabama 1093 4932 126
1810272 1810272 2021-10-13 Marion Arkansas 5089 2111 57
1810480 1810480 2021-10-13 Marion Florida 12083 56016 1659
1810603 1810603 2021-10-13 Marion Georgia 13197 953 35
1810776 1810776 2021-10-13 Marion Illinois 17121 6851 149
1810870 1810870 2021-10-13 Marion Indiana 18097 134058 2165
1810976 1810976 2021-10-13 Marion Iowa 19125 5000 91
1811070 1811070 2021-10-13 Marion Kansas 20115 1537 27
1811193 1811193 2021-10-13 Marion Kentucky 21155 3814 43
1811578 1811578 2021-10-13 Marion Mississippi 28091 4205 106
1811679 1811679 2021-10-13 Marion Missouri 29127 5114 63
1812229 1812229 2021-10-13 Marion Ohio 39101 11675 169
1812369 1812369 2021-10-13 Marion Oregon 41047 35835 440
1812566 1812566 2021-10-13 Marion South Carolina 45067 5381 134
1812701 1812701 2021-10-13 Marion Tennessee 47115 5675 52
1812896 1812896 2021-10-13 Marion Texas 48315 1155 48
1813239 1813239 2021-10-13 Marion West Virginia 54049 7552 90
1806914 1806914 2021-10-12 Marion Alabama 1093 4925 126
1807023 1807023 2021-10-12 Marion Arkansas 5089 2109 57
1807231 1807231 2021-10-12 Marion Florida 12083 56016 1659
1807354 1807354 2021-10-12 Marion Georgia 13197 953 35
1807527 1807527 2021-10-12 Marion Illinois 17121 6852 147
1807621 1807621 2021-10-12 Marion Indiana 18097 133860 2164
1807727 1807727 2021-10-12 Marion Iowa 19125 4889 89
1807821 1807821 2021-10-12 Marion Kansas 20115 1516 27
1807944 1807944 2021-10-12 Marion Kentucky 21155 3807 42
1808329 1808329 2021-10-12 Marion Mississippi 28091 4200 106
1808430 1808430 2021-10-12 Marion Missouri 29127 5110 58
1808980 1808980 2021-10-12 Marion Ohio 39101 11632 169
1809120 1809120 2021-10-12 Marion Oregon 41047 35705 439
1809317 1809317 2021-10-12 Marion South Carolina 45067 5372 134
1809452 1809452 2021-10-12 Marion Tennessee 47115 5658 52
1809647 1809647 2021-10-12 Marion Texas 48315 1153 46
1809990 1809990 2021-10-12 Marion West Virginia 54049 7513 90
1803663 1803663 2021-10-11 Marion Alabama 1093 4916 126
1803772 1803772 2021-10-11 Marion Arkansas 5089 2109 57
1803980 1803980 2021-10-11 Marion Florida 12083 56016 1659
1804103 1804103 2021-10-11 Marion Georgia 13197 949 35
1804276 1804276 2021-10-11 Marion Illinois 17121 6800 147
1804370 1804370 2021-10-11 Marion Indiana 18097 133676 2153
1804476 1804476 2021-10-11 Marion Iowa 19125 4889 89
1804570 1804570 2021-10-11 Marion Kansas 20115 1516 27
1804693 1804693 2021-10-11 Marion Kentucky 21155 3788 40
1805078 1805078 2021-10-11 Marion Mississippi 28091 4195 106
1805179 1805179 2021-10-11 Marion Missouri 29127 5108 58
1805730 1805730 2021-10-11 Marion Ohio 39101 11590 169
1805870 1805870 2021-10-11 Marion Oregon 41047 35596 432
1806067 1806067 2021-10-11 Marion South Carolina 45067 5368 134
1806202 1806202 2021-10-11 Marion Tennessee 47115 5649 52
1806397 1806397 2021-10-11 Marion Texas 48315 1150 46
1806741 1806741 2021-10-11 Marion West Virginia 54049 7478 89
1800414 1800414 2021-10-10 Marion Alabama 1093 4914 126
1800523 1800523 2021-10-10 Marion Arkansas 5089 2108 56
1800731 1800731 2021-10-10 Marion Florida 12083 56016 1659
1800854 1800854 2021-10-10 Marion Georgia 13197 949 35
1801027 1801027 2021-10-10 Marion Illinois 17121 6800 147
1801121 1801121 2021-10-10 Marion Indiana 18097 133113 2138
1801227 1801227 2021-10-10 Marion Iowa 19125 4889 89
1801321 1801321 2021-10-10 Marion Kansas 20115 1503 27
1801444 1801444 2021-10-10 Marion Kentucky 21155 3771 40
1801829 1801829 2021-10-10 Marion Mississippi 28091 4183 106
1801930 1801930 2021-10-10 Marion Missouri 29127 5107 58
1802480 1802480 2021-10-10 Marion Ohio 39101 11561 169
1802620 1802620 2021-10-10 Marion Oregon 41047 35321 430
1802817 1802817 2021-10-10 Marion South Carolina 45067 5348 134
1802952 1802952 2021-10-10 Marion Tennessee 47115 5635 52

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);