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,868 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 · 5,868 ✖
Link rowid date ▲ county state fips cases deaths
1095745 1095745 2021-03-07 Marion Alabama 1093 2889 96
1095853 1095853 2021-03-07 Marion Arkansas 5089 981 29
1096061 1096061 2021-03-07 Marion Florida 12083 28074 855
1096184 1096184 2021-03-07 Marion Georgia 13197 538 15
1096356 1096356 2021-03-07 Marion Illinois 17121 4280 119
1096450 1096450 2021-03-07 Marion Indiana 18097 91559 1727
1096556 1096556 2021-03-07 Marion Iowa 19125 3346 72
1096650 1096650 2021-03-07 Marion Kansas 20115 1029 24
1096774 1096774 2021-03-07 Marion Kentucky 21155 2169 25
1097159 1097159 2021-03-07 Marion Mississippi 28091 2588 78
1097260 1097260 2021-03-07 Marion Missouri 29127 2655 42
1097810 1097810 2021-03-07 Marion Ohio 39101 8021 127
1097950 1097950 2021-03-07 Marion Oregon 41047 18640 287
1098147 1098147 2021-03-07 Marion South Carolina 45067 3274 101
1098282 1098282 2021-03-07 Marion Tennessee 47115 2963 45
1098477 1098477 2021-03-07 Marion Texas 48315 521 30
1098820 1098820 2021-03-07 Marion West Virginia 54049 3715 34
1092499 1092499 2021-03-06 Marion Alabama 1093 2887 96
1092607 1092607 2021-03-06 Marion Arkansas 5089 981 29
1092815 1092815 2021-03-06 Marion Florida 12083 28026 852
1092938 1092938 2021-03-06 Marion Georgia 13197 538 15
1093110 1093110 2021-03-06 Marion Illinois 17121 4276 119
1093204 1093204 2021-03-06 Marion Indiana 18097 91476 1726
1093310 1093310 2021-03-06 Marion Iowa 19125 3346 71
1093404 1093404 2021-03-06 Marion Kansas 20115 1029 24
1093528 1093528 2021-03-06 Marion Kentucky 21155 2166 25
1093912 1093912 2021-03-06 Marion Mississippi 28091 2588 78
1094013 1094013 2021-03-06 Marion Missouri 29127 2654 42
1094562 1094562 2021-03-06 Marion Ohio 39101 8020 127
1094702 1094702 2021-03-06 Marion Oregon 41047 18625 287
1094899 1094899 2021-03-06 Marion South Carolina 45067 3273 100
1095034 1095034 2021-03-06 Marion Tennessee 47115 2959 45
1095229 1095229 2021-03-06 Marion Texas 48315 521 29
1095572 1095572 2021-03-06 Marion West Virginia 54049 3726 34
1089253 1089253 2021-03-05 Marion Alabama 1093 2885 95
1089361 1089361 2021-03-05 Marion Arkansas 5089 977 29
1089569 1089569 2021-03-05 Marion Florida 12083 27957 844
1089692 1089692 2021-03-05 Marion Georgia 13197 537 15
1089864 1089864 2021-03-05 Marion Illinois 17121 4272 118
1089958 1089958 2021-03-05 Marion Indiana 18097 91264 1722
1090064 1090064 2021-03-05 Marion Iowa 19125 3346 71
1090158 1090158 2021-03-05 Marion Kansas 20115 1029 24
1090282 1090282 2021-03-05 Marion Kentucky 21155 2165 24
1090666 1090666 2021-03-05 Marion Mississippi 28091 2528 78
1090767 1090767 2021-03-05 Marion Missouri 29127 2652 42
1091316 1091316 2021-03-05 Marion Ohio 39101 8015 127
1091456 1091456 2021-03-05 Marion Oregon 41047 18600 287
1091653 1091653 2021-03-05 Marion South Carolina 45067 3267 100
1091788 1091788 2021-03-05 Marion Tennessee 47115 2952 45
1091983 1091983 2021-03-05 Marion Texas 48315 521 28
1092326 1092326 2021-03-05 Marion West Virginia 54049 3705 34
1086008 1086008 2021-03-04 Marion Alabama 1093 2886 95
1086116 1086116 2021-03-04 Marion Arkansas 5089 975 29
1086324 1086324 2021-03-04 Marion Florida 12083 27879 827
1086447 1086447 2021-03-04 Marion Georgia 13197 537 15
1086619 1086619 2021-03-04 Marion Illinois 17121 4270 118
1086713 1086713 2021-03-04 Marion Indiana 18097 91158 1719
1086819 1086819 2021-03-04 Marion Iowa 19125 3346 70
1086913 1086913 2021-03-04 Marion Kansas 20115 1029 24
1087037 1087037 2021-03-04 Marion Kentucky 21155 2161 24
1087421 1087421 2021-03-04 Marion Mississippi 28091 2527 78
1087522 1087522 2021-03-04 Marion Missouri 29127 2651 42
1088071 1088071 2021-03-04 Marion Ohio 39101 8006 125
1088210 1088210 2021-03-04 Marion Oregon 41047 18579 287
1088407 1088407 2021-03-04 Marion South Carolina 45067 3260 100
1088542 1088542 2021-03-04 Marion Tennessee 47115 2947 44
1088737 1088737 2021-03-04 Marion Texas 48315 520 28
1089080 1089080 2021-03-04 Marion West Virginia 54049 3696 34
1082762 1082762 2021-03-03 Marion Alabama 1093 2888 95
1082870 1082870 2021-03-03 Marion Arkansas 5089 975 29
1083078 1083078 2021-03-03 Marion Florida 12083 27819 815
1083201 1083201 2021-03-03 Marion Georgia 13197 535 15
1083373 1083373 2021-03-03 Marion Illinois 17121 4268 118
1083467 1083467 2021-03-03 Marion Indiana 18097 91058 1716
1083573 1083573 2021-03-03 Marion Iowa 19125 3346 69
1083667 1083667 2021-03-03 Marion Kansas 20115 1029 24
1083791 1083791 2021-03-03 Marion Kentucky 21155 2160 24
1084176 1084176 2021-03-03 Marion Mississippi 28091 2527 78
1084277 1084277 2021-03-03 Marion Missouri 29127 2646 42
1084826 1084826 2021-03-03 Marion Ohio 39101 7996 125
1084965 1084965 2021-03-03 Marion Oregon 41047 18541 285
1085162 1085162 2021-03-03 Marion South Carolina 45067 3257 99
1085297 1085297 2021-03-03 Marion Tennessee 47115 2945 44
1085492 1085492 2021-03-03 Marion Texas 48315 520 28
1085835 1085835 2021-03-03 Marion West Virginia 54049 3689 34
1079516 1079516 2021-03-02 Marion Alabama 1093 2834 95
1079624 1079624 2021-03-02 Marion Arkansas 5089 973 29
1079832 1079832 2021-03-02 Marion Florida 12083 27750 806
1079955 1079955 2021-03-02 Marion Georgia 13197 532 15
1080127 1080127 2021-03-02 Marion Illinois 17121 4261 117
1080221 1080221 2021-03-02 Marion Indiana 18097 90976 1716
1080327 1080327 2021-03-02 Marion Iowa 19125 3346 69
1080421 1080421 2021-03-02 Marion Kansas 20115 1024 23
1080545 1080545 2021-03-02 Marion Kentucky 21155 2155 24
1080930 1080930 2021-03-02 Marion Mississippi 28091 2527 78
1081031 1081031 2021-03-02 Marion Missouri 29127 2646 41
1081580 1081580 2021-03-02 Marion Ohio 39101 7989 125
1081719 1081719 2021-03-02 Marion Oregon 41047 18513 285
1081916 1081916 2021-03-02 Marion South Carolina 45067 3253 98
1082051 1082051 2021-03-02 Marion Tennessee 47115 2941 44

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