ny_times_us_counties

⚠️ 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

1,669 rows where county = "Marion" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Marion · 1,669
Link rowid date ▲ county state fips cases deaths
291806 2020-07-03 Marion Alabama 1093 218 13
291913 2020-07-03 Marion Arkansas 5089 11 0
292117 2020-07-03 Marion Florida 12083 817 12
292240 2020-07-03 Marion Georgia 13197 86 2
292408 2020-07-03 Marion Illinois 17121 68 0
292502 2020-07-03 Marion Indiana 18097 11630 730
292608 2020-07-03 Marion Iowa 19125 68 0
292697 2020-07-03 Marion Kansas 20115 12 1
292816 2020-07-03 Marion Kentucky 21155 52 0
293199 2020-07-03 Marion Mississippi 28091 270 11
293299 2020-07-03 Marion Missouri 29127 25 0
293810 2020-07-03 Marion Ohio 39101 2730 38
293946 2020-07-03 Marion Oregon 41047 1595 47
294064 2020-07-03 Marion South Carolina 45067 234 8
294193 2020-07-03 Marion Tennessee 47115 71 4
294382 2020-07-03 Marion Texas 48315 28 1
294715 2020-07-03 Marion West Virginia 54049 66 2
288730 2020-07-02 Marion Alabama 1093 210 13
288836 2020-07-02 Marion Arkansas 5089 11 0
289040 2020-07-02 Marion Florida 12083 789 10
289163 2020-07-02 Marion Georgia 13197 83 2
289330 2020-07-02 Marion Illinois 17121 66 0
289423 2020-07-02 Marion Indiana 18097 11560 727
289529 2020-07-02 Marion Iowa 19125 68 0
289618 2020-07-02 Marion Kansas 20115 11 1
289737 2020-07-02 Marion Kentucky 21155 52 0
290120 2020-07-02 Marion Mississippi 28091 263 11
290220 2020-07-02 Marion Missouri 29127 20 0
290729 2020-07-02 Marion Ohio 39101 2731 38
290866 2020-07-02 Marion Oregon 41047 1564 47
290984 2020-07-02 Marion South Carolina 45067 214 7
291112 2020-07-02 Marion Tennessee 47115 67 4
291300 2020-07-02 Marion Texas 48315 28 1
291632 2020-07-02 Marion West Virginia 54049 63 2
285656 2020-07-01 Marion Alabama 1093 208 12
285761 2020-07-01 Marion Arkansas 5089 6 0
285965 2020-07-01 Marion Florida 12083 727 10
286088 2020-07-01 Marion Georgia 13197 82 2
286255 2020-07-01 Marion Illinois 17121 66 0
286348 2020-07-01 Marion Indiana 18097 11513 727
286454 2020-07-01 Marion Iowa 19125 67 0
286543 2020-07-01 Marion Kansas 20115 11 1
286662 2020-07-01 Marion Kentucky 21155 52 0
287045 2020-07-01 Marion Mississippi 28091 248 11
287145 2020-07-01 Marion Missouri 29127 19 0
287653 2020-07-01 Marion Ohio 39101 2731 38
287789 2020-07-01 Marion Oregon 41047 1539 47
287907 2020-07-01 Marion South Carolina 45067 212 7
288035 2020-07-01 Marion Tennessee 47115 67 4
288224 2020-07-01 Marion Texas 48315 28 1
288556 2020-07-01 Marion West Virginia 54049 61 2
282583 2020-06-30 Marion Alabama 1093 205 12
282688 2020-06-30 Marion Arkansas 5089 6 0
282892 2020-06-30 Marion Florida 12083 672 10
283015 2020-06-30 Marion Georgia 13197 79 2
283183 2020-06-30 Marion Illinois 17121 65 0
283276 2020-06-30 Marion Indiana 18097 11451 726
283382 2020-06-30 Marion Iowa 19125 67 0
283472 2020-06-30 Marion Kansas 20115 11 1
283591 2020-06-30 Marion Kentucky 21155 51 0
283973 2020-06-30 Marion Mississippi 28091 240 11
284073 2020-06-30 Marion Missouri 29127 17 0
284580 2020-06-30 Marion Ohio 39101 2726 38
284716 2020-06-30 Marion Oregon 41047 1514 46
284834 2020-06-30 Marion South Carolina 45067 208 7
284962 2020-06-30 Marion Tennessee 47115 64 4
285150 2020-06-30 Marion Texas 48315 26 1
285482 2020-06-30 Marion West Virginia 54049 59 2
279514 2020-06-29 Marion Alabama 1093 202 12
279619 2020-06-29 Marion Arkansas 5089 4 0
279823 2020-06-29 Marion Florida 12083 655 10
279946 2020-06-29 Marion Georgia 13197 78 2
280111 2020-06-29 Marion Illinois 17121 65 0
280204 2020-06-29 Marion Indiana 18097 11401 724
280310 2020-06-29 Marion Iowa 19125 64 0
280400 2020-06-29 Marion Kansas 20115 11 1
280519 2020-06-29 Marion Kentucky 21155 51 0
280900 2020-06-29 Marion Mississippi 28091 233 11
281000 2020-06-29 Marion Missouri 29127 16 0
281507 2020-06-29 Marion Ohio 39101 2724 37
281642 2020-06-29 Marion Oregon 41047 1489 43
281760 2020-06-29 Marion South Carolina 45067 193 7
281888 2020-06-29 Marion Tennessee 47115 61 4
282077 2020-06-29 Marion Texas 48315 26 1
282409 2020-06-29 Marion West Virginia 54049 55 2
276446 2020-06-28 Marion Alabama 1093 194 12
276551 2020-06-28 Marion Arkansas 5089 4 0
276755 2020-06-28 Marion Florida 12083 631 10
276878 2020-06-28 Marion Georgia 13197 78 2
277044 2020-06-28 Marion Illinois 17121 65 0
277137 2020-06-28 Marion Indiana 18097 11358 724
277243 2020-06-28 Marion Iowa 19125 60 0
277332 2020-06-28 Marion Kansas 20115 10 1
277450 2020-06-28 Marion Kentucky 21155 49 0
277832 2020-06-28 Marion Mississippi 28091 228 11
277932 2020-06-28 Marion Missouri 29127 16 0
278439 2020-06-28 Marion Ohio 39101 2721 37
278574 2020-06-28 Marion Oregon 41047 1475 41
278692 2020-06-28 Marion South Carolina 45067 191 7
278820 2020-06-28 Marion Tennessee 47115 57 4

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
);
Powered by Datasette · Query took 932.518ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette