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

13,212 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 17

fips 17

county 1

  • Marion · 13,212 ✖
Link rowid date ▲ county state fips cases deaths
2499621 2499621 2022-05-13 Marion Alabama 1093 8157 152
2499730 2499730 2022-05-13 Marion Arkansas 5089 3409 88
2499938 2499938 2022-05-13 Marion Florida 12083 84120 2105
2500061 2500061 2022-05-13 Marion Georgia 13197 1520 50
2500234 2500234 2022-05-13 Marion Illinois 17121 11933 217
2500328 2500328 2022-05-13 Marion Indiana 18097 227486 3000
2500435 2500435 2022-05-13 Marion Iowa 19125 7590 125
2500529 2500529 2022-05-13 Marion Kansas 20115 3337 43
2500653 2500653 2022-05-13 Marion Kentucky 21155 6433 85
2501038 2501038 2022-05-13 Marion Mississippi 28091 6974 135
2501140 2501140 2022-05-13 Marion Missouri 29127 8051 118
2501694 2501694 2022-05-13 Marion Ohio 39101 20070 268
2501834 2501834 2022-05-13 Marion Oregon 41047 70744 721
2502031 2502031 2022-05-13 Marion South Carolina 45067 8564 163
2502166 2502166 2022-05-13 Marion Tennessee 47115 8870 132
2502361 2502361 2022-05-13 Marion Texas 48315 1690 60
2502706 2502706 2022-05-13 Marion West Virginia 54049 15266 179
2496363 2496363 2022-05-12 Marion Alabama 1093 8153 152
2496472 2496472 2022-05-12 Marion Arkansas 5089 3408 88
2496680 2496680 2022-05-12 Marion Florida 12083 84120 2105
2496803 2496803 2022-05-12 Marion Georgia 13197 1520 50
2496976 2496976 2022-05-12 Marion Illinois 17121 11929 217
2497070 2497070 2022-05-12 Marion Indiana 18097 227159 3000
2497177 2497177 2022-05-12 Marion Iowa 19125 7590 125
2497271 2497271 2022-05-12 Marion Kansas 20115 3336 43
2497395 2497395 2022-05-12 Marion Kentucky 21155 6433 85
2497780 2497780 2022-05-12 Marion Mississippi 28091 6974 135
2497882 2497882 2022-05-12 Marion Missouri 29127 7989 118
2498436 2498436 2022-05-12 Marion Ohio 39101 20070 268
2498576 2498576 2022-05-12 Marion Oregon 41047 70656 721
2498773 2498773 2022-05-12 Marion South Carolina 45067 8564 163
2498908 2498908 2022-05-12 Marion Tennessee 47115 8870 132
2499103 2499103 2022-05-12 Marion Texas 48315 1690 60
2499448 2499448 2022-05-12 Marion West Virginia 54049 15243 179
2493105 2493105 2022-05-11 Marion Alabama 1093 8151 152
2493214 2493214 2022-05-11 Marion Arkansas 5089 3405 88
2493422 2493422 2022-05-11 Marion Florida 12083 84120 2105
2493545 2493545 2022-05-11 Marion Georgia 13197 1520 50
2493718 2493718 2022-05-11 Marion Illinois 17121 11925 217
2493812 2493812 2022-05-11 Marion Indiana 18097 227159 3000
2493919 2493919 2022-05-11 Marion Iowa 19125 7590 125
2494013 2494013 2022-05-11 Marion Kansas 20115 3336 43
2494137 2494137 2022-05-11 Marion Kentucky 21155 6433 85
2494522 2494522 2022-05-11 Marion Mississippi 28091 6974 135
2494624 2494624 2022-05-11 Marion Missouri 29127 7989 118
2495178 2495178 2022-05-11 Marion Ohio 39101 19996 268
2495318 2495318 2022-05-11 Marion Oregon 41047 70564 720
2495515 2495515 2022-05-11 Marion South Carolina 45067 8564 163
2495650 2495650 2022-05-11 Marion Tennessee 47115 8870 132
2495845 2495845 2022-05-11 Marion Texas 48315 1690 60
2496190 2496190 2022-05-11 Marion West Virginia 54049 15215 179
2489847 2489847 2022-05-10 Marion Alabama 1093 8150 152
2489956 2489956 2022-05-10 Marion Arkansas 5089 3405 88
2490164 2490164 2022-05-10 Marion Florida 12083 84120 2099
2490287 2490287 2022-05-10 Marion Georgia 13197 1520 50
2490460 2490460 2022-05-10 Marion Illinois 17121 11919 217
2490554 2490554 2022-05-10 Marion Indiana 18097 227007 3000
2490661 2490661 2022-05-10 Marion Iowa 19125 7581 125
2490755 2490755 2022-05-10 Marion Kansas 20115 3336 43
2490879 2490879 2022-05-10 Marion Kentucky 21155 6433 85
2491264 2491264 2022-05-10 Marion Mississippi 28091 6974 135
2491366 2491366 2022-05-10 Marion Missouri 29127 7989 118
2491920 2491920 2022-05-10 Marion Ohio 39101 19996 268
2492060 2492060 2022-05-10 Marion Oregon 41047 70476 720
2492257 2492257 2022-05-10 Marion South Carolina 45067 8551 163
2492392 2492392 2022-05-10 Marion Tennessee 47115 8863 132
2492587 2492587 2022-05-10 Marion Texas 48315 1690 60
2492932 2492932 2022-05-10 Marion West Virginia 54049 15169 178
2486590 2486590 2022-05-09 Marion Alabama 1093 8139 152
2486699 2486699 2022-05-09 Marion Arkansas 5089 3405 88
2486907 2486907 2022-05-09 Marion Florida 12083 84120 2099
2487030 2487030 2022-05-09 Marion Georgia 13197 1520 50
2487203 2487203 2022-05-09 Marion Illinois 17121 11916 217
2487297 2487297 2022-05-09 Marion Indiana 18097 227007 3000
2487404 2487404 2022-05-09 Marion Iowa 19125 7581 125
2487498 2487498 2022-05-09 Marion Kansas 20115 3336 43
2487622 2487622 2022-05-09 Marion Kentucky 21155 6433 85
2488007 2488007 2022-05-09 Marion Mississippi 28091 6974 135
2488108 2488108 2022-05-09 Marion Missouri 29127 7989 118
2488662 2488662 2022-05-09 Marion Ohio 39101 19996 268
2488802 2488802 2022-05-09 Marion Oregon 41047 70376 720
2488999 2488999 2022-05-09 Marion South Carolina 45067 8551 163
2489134 2489134 2022-05-09 Marion Tennessee 47115 8863 132
2489329 2489329 2022-05-09 Marion Texas 48315 1690 60
2489674 2489674 2022-05-09 Marion West Virginia 54049 15169 178
2483332 2483332 2022-05-08 Marion Alabama 1093 8139 152
2483441 2483441 2022-05-08 Marion Arkansas 5089 3405 88
2483649 2483649 2022-05-08 Marion Florida 12083 84120 2099
2483772 2483772 2022-05-08 Marion Georgia 13197 1519 50
2483945 2483945 2022-05-08 Marion Illinois 17121 11914 217
2484039 2484039 2022-05-08 Marion Indiana 18097 226560 2995
2484146 2484146 2022-05-08 Marion Iowa 19125 7581 125
2484240 2484240 2022-05-08 Marion Kansas 20115 3336 43
2484364 2484364 2022-05-08 Marion Kentucky 21155 6422 85
2484749 2484749 2022-05-08 Marion Mississippi 28091 6965 135
2484851 2484851 2022-05-08 Marion Missouri 29127 7989 118
2485405 2485405 2022-05-08 Marion Ohio 39101 19996 268
2485545 2485545 2022-05-08 Marion Oregon 41047 70186 718
2485742 2485742 2022-05-08 Marion South Carolina 45067 8551 163
2485877 2485877 2022-05-08 Marion Tennessee 47115 8863 132

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