ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,212 rows where county = "Marion" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
614 | 614 | 2020-03-06 | Marion | Indiana | 18097 | 1 | 0 |
698 | 698 | 2020-03-07 | Marion | Indiana | 18097 | 1 | 0 |
796 | 796 | 2020-03-08 | Marion | Indiana | 18097 | 1 | 0 |
833 | 833 | 2020-03-08 | Marion | Oregon | 41047 | 1 | 0 |
916 | 916 | 2020-03-09 | Marion | Indiana | 18097 | 1 | 0 |
961 | 961 | 2020-03-09 | Marion | Oregon | 41047 | 1 | 0 |
1061 | 1061 | 2020-03-10 | Marion | Indiana | 18097 | 1 | 0 |
1112 | 1112 | 2020-03-10 | Marion | Oregon | 41047 | 1 | 0 |
1238 | 1238 | 2020-03-11 | Marion | Indiana | 18097 | 1 | 0 |
5805 | 5805 | 2020-03-20 | Marion | Ohio | 39101 | 1 | 0 |
6095 | 6095 | 2020-03-21 | Marion | Alabama | 1093 | 1 | 0 |
6806 | 6806 | 2020-03-21 | Marion | Ohio | 39101 | 1 | 0 |
7129 | 7129 | 2020-03-22 | Marion | Alabama | 1093 | 1 | 0 |
7917 | 7917 | 2020-03-22 | Marion | Ohio | 39101 | 1 | 0 |
8059 | 8059 | 2020-03-22 | Marion | Tennessee | 47115 | 1 | 0 |
8269 | 8269 | 2020-03-23 | Marion | Alabama | 1093 | 1 | 0 |
8867 | 8867 | 2020-03-23 | Marion | Mississippi | 28091 | 1 | 0 |
9277 | 9277 | 2020-03-23 | Marion | Tennessee | 47115 | 1 | 0 |
9496 | 9496 | 2020-03-24 | Marion | Alabama | 1093 | 1 | 0 |
10163 | 10163 | 2020-03-24 | Marion | Mississippi | 28091 | 1 | 0 |
10610 | 10610 | 2020-03-24 | Marion | Tennessee | 47115 | 1 | 0 |
11583 | 11583 | 2020-03-25 | Marion | Mississippi | 28091 | 1 | 0 |
12031 | 12031 | 2020-03-25 | Marion | South Carolina | 45067 | 1 | 0 |
12089 | 12089 | 2020-03-25 | Marion | Tennessee | 47115 | 1 | 0 |
12314 | 12314 | 2020-03-25 | Marion | West Virginia | 54049 | 1 | 0 |
13176 | 13176 | 2020-03-26 | Marion | Mississippi | 28091 | 1 | 0 |
13653 | 13653 | 2020-03-26 | Marion | South Carolina | 45067 | 1 | 0 |
14894 | 14894 | 2020-03-27 | Marion | Mississippi | 28091 | 1 | 0 |
15400 | 15400 | 2020-03-27 | Marion | South Carolina | 45067 | 1 | 0 |
17255 | 17255 | 2020-03-28 | Marion | South Carolina | 45067 | 1 | 0 |
19195 | 19195 | 2020-03-29 | Marion | South Carolina | 45067 | 1 | 0 |
20376 | 20376 | 2020-03-30 | Marion | Kentucky | 21155 | 1 | 0 |
22481 | 22481 | 2020-03-31 | Marion | Kentucky | 21155 | 1 | 0 |
24657 | 24657 | 2020-04-01 | Marion | Kentucky | 21155 | 1 | 0 |
26905 | 26905 | 2020-04-02 | Marion | Kentucky | 21155 | 1 | 0 |
28816 | 28816 | 2020-04-03 | Marion | Georgia | 13197 | 1 | 0 |
29154 | 29154 | 2020-04-03 | Marion | Kansas | 20115 | 1 | 0 |
29221 | 29221 | 2020-04-03 | Marion | Kentucky | 21155 | 1 | 0 |
36343 | 36343 | 2020-04-06 | Marion | Iowa | 19125 | 1 | 0 |
45930 | 45930 | 2020-04-10 | Marion | Arkansas | 5089 | 1 | 0 |
48560 | 48560 | 2020-04-11 | Marion | Arkansas | 5089 | 1 | 0 |
51222 | 51222 | 2020-04-12 | Marion | Arkansas | 5089 | 1 | 0 |
53901 | 53901 | 2020-04-13 | Marion | Arkansas | 5089 | 1 | 0 |
56593 | 56593 | 2020-04-14 | Marion | Arkansas | 5089 | 1 | 0 |
59301 | 59301 | 2020-04-15 | Marion | Arkansas | 5089 | 1 | 0 |
62020 | 62020 | 2020-04-16 | Marion | Arkansas | 5089 | 1 | 0 |
64753 | 64753 | 2020-04-17 | Marion | Arkansas | 5089 | 1 | 0 |
67501 | 67501 | 2020-04-18 | Marion | Arkansas | 5089 | 1 | 0 |
68772 | 68772 | 2020-04-18 | Marion | Missouri | 29127 | 1 | 0 |
70263 | 70263 | 2020-04-19 | Marion | Arkansas | 5089 | 1 | 0 |
71539 | 71539 | 2020-04-19 | Marion | Missouri | 29127 | 1 | 0 |
73032 | 73032 | 2020-04-20 | Marion | Arkansas | 5089 | 1 | 0 |
75808 | 75808 | 2020-04-21 | Marion | Arkansas | 5089 | 1 | 0 |
78592 | 78592 | 2020-04-22 | Marion | Arkansas | 5089 | 1 | 0 |
81386 | 81386 | 2020-04-23 | Marion | Arkansas | 5089 | 1 | 0 |
84186 | 84186 | 2020-04-24 | Marion | Arkansas | 5089 | 1 | 0 |
86994 | 86994 | 2020-04-25 | Marion | Arkansas | 5089 | 1 | 0 |
89811 | 89811 | 2020-04-26 | Marion | Arkansas | 5089 | 1 | 0 |
92629 | 92629 | 2020-04-27 | Marion | Arkansas | 5089 | 1 | 0 |
95459 | 95459 | 2020-04-28 | Marion | Arkansas | 5089 | 1 | 0 |
98304 | 98304 | 2020-04-29 | Marion | Arkansas | 5089 | 1 | 0 |
101154 | 101154 | 2020-04-30 | Marion | Arkansas | 5089 | 1 | 0 |
104009 | 104009 | 2020-05-01 | Marion | Arkansas | 5089 | 1 | 0 |
106874 | 106874 | 2020-05-02 | Marion | Arkansas | 5089 | 1 | 0 |
109743 | 109743 | 2020-05-03 | Marion | Arkansas | 5089 | 1 | 0 |
112618 | 112618 | 2020-05-04 | Marion | Arkansas | 5089 | 1 | 0 |
115501 | 115501 | 2020-05-05 | Marion | Arkansas | 5089 | 1 | 0 |
118460 | 118460 | 2020-05-06 | Marion | Arkansas | 5089 | 1 | 0 |
121427 | 121427 | 2020-05-07 | Marion | Arkansas | 5089 | 1 | 0 |
124407 | 124407 | 2020-05-08 | Marion | Arkansas | 5089 | 1 | 0 |
127392 | 127392 | 2020-05-09 | Marion | Arkansas | 5089 | 1 | 0 |
130382 | 130382 | 2020-05-10 | Marion | Arkansas | 5089 | 1 | 0 |
133372 | 133372 | 2020-05-11 | Marion | Arkansas | 5089 | 1 | 0 |
136362 | 136362 | 2020-05-12 | Marion | Arkansas | 5089 | 1 | 0 |
139353 | 139353 | 2020-05-13 | Marion | Arkansas | 5089 | 1 | 0 |
142349 | 142349 | 2020-05-14 | Marion | Arkansas | 5089 | 1 | 0 |
145348 | 145348 | 2020-05-15 | Marion | Arkansas | 5089 | 1 | 0 |
148352 | 148352 | 2020-05-16 | Marion | Arkansas | 5089 | 1 | 0 |
151361 | 151361 | 2020-05-17 | Marion | Arkansas | 5089 | 1 | 0 |
154373 | 154373 | 2020-05-18 | Marion | Arkansas | 5089 | 1 | 0 |
157389 | 157389 | 2020-05-19 | Marion | Arkansas | 5089 | 1 | 0 |
160415 | 160415 | 2020-05-20 | Marion | Arkansas | 5089 | 1 | 0 |
163443 | 163443 | 2020-05-21 | Marion | Arkansas | 5089 | 1 | 0 |
166475 | 166475 | 2020-05-22 | Marion | Arkansas | 5089 | 1 | 0 |
169511 | 169511 | 2020-05-23 | Marion | Arkansas | 5089 | 1 | 0 |
172552 | 172552 | 2020-05-24 | Marion | Arkansas | 5089 | 1 | 0 |
175596 | 175596 | 2020-05-25 | Marion | Arkansas | 5089 | 1 | 0 |
178640 | 178640 | 2020-05-26 | Marion | Arkansas | 5089 | 1 | 0 |
181684 | 181684 | 2020-05-27 | Marion | Arkansas | 5089 | 1 | 0 |
184738 | 184738 | 2020-05-28 | Marion | Arkansas | 5089 | 1 | 0 |
187794 | 187794 | 2020-05-29 | Marion | Arkansas | 5089 | 1 | 0 |
190859 | 190859 | 2020-05-30 | Marion | Arkansas | 5089 | 1 | 0 |
1303 | 1303 | 2020-03-11 | Marion | Oregon | 41047 | 2 | 0 |
1452 | 1452 | 2020-03-12 | Marion | Indiana | 18097 | 2 | 0 |
1547 | 1547 | 2020-03-12 | Marion | Oregon | 41047 | 2 | 0 |
1723 | 1723 | 2020-03-13 | Marion | Indiana | 18097 | 2 | 0 |
1843 | 1843 | 2020-03-13 | Marion | Oregon | 41047 | 2 | 0 |
2204 | 2204 | 2020-03-14 | Marion | Oregon | 41047 | 2 | 0 |
2623 | 2623 | 2020-03-15 | Marion | Oregon | 41047 | 2 | 0 |
6246 | 6246 | 2020-03-21 | Marion | Florida | 12083 | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);