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

5,120 rows where county = "Marion" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Marion · 5,120 ✖
Link rowid date ▲ county state fips cases deaths
953018 953018 2021-01-22 Marion Alabama 1093 2515 58
953126 953126 2021-01-22 Marion Arkansas 5089 821 27
953334 953334 2021-01-22 Marion Florida 12083 23050 560
953457 953457 2021-01-22 Marion Georgia 13197 420 10
953629 953629 2021-01-22 Marion Illinois 17121 4051 113
953722 953722 2021-01-22 Marion Indiana 18097 83820 1394
953828 953828 2021-01-22 Marion Iowa 19125 3081 52
953922 953922 2021-01-22 Marion Kansas 20115 908 1
954046 954046 2021-01-22 Marion Kentucky 21155 1798 20
954431 954431 2021-01-22 Marion Mississippi 28091 2202 73
954532 954532 2021-01-22 Marion Missouri 29127 2547 34
955081 955081 2021-01-22 Marion Ohio 39101 7437 113
955220 955220 2021-01-22 Marion Oregon 41047 16575 246
955417 955417 2021-01-22 Marion South Carolina 45067 2746 83
955552 955552 2021-01-22 Marion Tennessee 47115 2339 32
955747 955747 2021-01-22 Marion Texas 48315 414 21
956090 956090 2021-01-22 Marion West Virginia 54049 3054 24
949773 949773 2021-01-21 Marion Alabama 1093 2501 55
949881 949881 2021-01-21 Marion Arkansas 5089 813 27
950089 950089 2021-01-21 Marion Florida 12083 22847 558
950212 950212 2021-01-21 Marion Georgia 13197 417 10
950384 950384 2021-01-21 Marion Illinois 17121 4026 113
950477 950477 2021-01-21 Marion Indiana 18097 83308 1385
950583 950583 2021-01-21 Marion Iowa 19125 3072 52
950677 950677 2021-01-21 Marion Kansas 20115 892 1
950801 950801 2021-01-21 Marion Kentucky 21155 1794 20
951186 951186 2021-01-21 Marion Mississippi 28091 2184 73
951287 951287 2021-01-21 Marion Missouri 29127 2532 34
951836 951836 2021-01-21 Marion Ohio 39101 7420 113
951975 951975 2021-01-21 Marion Oregon 41047 16475 242
952172 952172 2021-01-21 Marion South Carolina 45067 2706 83
952307 952307 2021-01-21 Marion Tennessee 47115 2327 31
952502 952502 2021-01-21 Marion Texas 48315 409 20
952845 952845 2021-01-21 Marion West Virginia 54049 3023 24
946527 946527 2021-01-20 Marion Alabama 1093 2489 53
946635 946635 2021-01-20 Marion Arkansas 5089 803 27
946843 946843 2021-01-20 Marion Florida 12083 22644 556
946966 946966 2021-01-20 Marion Georgia 13197 412 10
947138 947138 2021-01-20 Marion Illinois 17121 4024 112
947231 947231 2021-01-20 Marion Indiana 18097 82828 1380
947337 947337 2021-01-20 Marion Iowa 19125 3057 52
947431 947431 2021-01-20 Marion Kansas 20115 892 1
947555 947555 2021-01-20 Marion Kentucky 21155 1776 20
947940 947940 2021-01-20 Marion Mississippi 28091 2150 73
948041 948041 2021-01-20 Marion Missouri 29127 2528 34
948591 948591 2021-01-20 Marion Ohio 39101 7398 113
948730 948730 2021-01-20 Marion Oregon 41047 16394 242
948927 948927 2021-01-20 Marion South Carolina 45067 2688 82
949062 949062 2021-01-20 Marion Tennessee 47115 2308 31
949257 949257 2021-01-20 Marion Texas 48315 405 20
949600 949600 2021-01-20 Marion West Virginia 54049 2977 24
943280 943280 2021-01-19 Marion Alabama 1093 2473 50
943388 943388 2021-01-19 Marion Arkansas 5089 796 27
943596 943596 2021-01-19 Marion Florida 12083 22424 553
943719 943719 2021-01-19 Marion Georgia 13197 411 10
943891 943891 2021-01-19 Marion Illinois 17121 3994 112
943984 943984 2021-01-19 Marion Indiana 18097 82482 1374
944090 944090 2021-01-19 Marion Iowa 19125 3049 52
944184 944184 2021-01-19 Marion Kansas 20115 871 1
944308 944308 2021-01-19 Marion Kentucky 21155 1764 20
944693 944693 2021-01-19 Marion Mississippi 28091 2130 73
944794 944794 2021-01-19 Marion Missouri 29127 2520 32
945345 945345 2021-01-19 Marion Ohio 39101 7377 113
945484 945484 2021-01-19 Marion Oregon 41047 16312 239
945681 945681 2021-01-19 Marion South Carolina 45067 2680 82
945816 945816 2021-01-19 Marion Tennessee 47115 2292 31
946011 946011 2021-01-19 Marion Texas 48315 401 20
946354 946354 2021-01-19 Marion West Virginia 54049 2944 23
940035 940035 2021-01-18 Marion Alabama 1093 2462 50
940143 940143 2021-01-18 Marion Arkansas 5089 794 27
940351 940351 2021-01-18 Marion Florida 12083 22266 551
940474 940474 2021-01-18 Marion Georgia 13197 410 10
940646 940646 2021-01-18 Marion Illinois 17121 3970 111
940739 940739 2021-01-18 Marion Indiana 18097 82090 1364
940845 940845 2021-01-18 Marion Iowa 19125 3038 52
940939 940939 2021-01-18 Marion Kansas 20115 871 1
941063 941063 2021-01-18 Marion Kentucky 21155 1750 20
941448 941448 2021-01-18 Marion Mississippi 28091 2120 72
941549 941549 2021-01-18 Marion Missouri 29127 2517 32
942098 942098 2021-01-18 Marion Ohio 39101 7341 113
942237 942237 2021-01-18 Marion Oregon 41047 16247 239
942434 942434 2021-01-18 Marion South Carolina 45067 2648 82
942569 942569 2021-01-18 Marion Tennessee 47115 2284 31
942764 942764 2021-01-18 Marion Texas 48315 393 20
943107 943107 2021-01-18 Marion West Virginia 54049 2914 23
936790 936790 2021-01-17 Marion Alabama 1093 2456 50
936898 936898 2021-01-17 Marion Arkansas 5089 792 27
937106 937106 2021-01-17 Marion Florida 12083 22141 541
937229 937229 2021-01-17 Marion Georgia 13197 410 10
937401 937401 2021-01-17 Marion Illinois 17121 3958 111
937494 937494 2021-01-17 Marion Indiana 18097 81755 1360
937600 937600 2021-01-17 Marion Iowa 19125 3021 52
937694 937694 2021-01-17 Marion Kansas 20115 847 1
937818 937818 2021-01-17 Marion Kentucky 21155 1746 20
938203 938203 2021-01-17 Marion Mississippi 28091 2106 72
938304 938304 2021-01-17 Marion Missouri 29127 2514 32
938853 938853 2021-01-17 Marion Ohio 39101 7319 113
938992 938992 2021-01-17 Marion Oregon 41047 16172 238
939189 939189 2021-01-17 Marion South Carolina 45067 2624 82
939324 939324 2021-01-17 Marion Tennessee 47115 2277 31

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