ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Marion" and fips = 28091 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
8867 | 8867 | 2020-03-23 | Marion | Mississippi | 28091 | 1 | 0 |
10163 | 10163 | 2020-03-24 | Marion | Mississippi | 28091 | 1 | 0 |
11583 | 11583 | 2020-03-25 | Marion | Mississippi | 28091 | 1 | 0 |
13176 | 13176 | 2020-03-26 | Marion | Mississippi | 28091 | 1 | 0 |
14894 | 14894 | 2020-03-27 | Marion | Mississippi | 28091 | 1 | 0 |
16718 | 16718 | 2020-03-28 | Marion | Mississippi | 28091 | 3 | 0 |
18640 | 18640 | 2020-03-29 | Marion | Mississippi | 28091 | 4 | 0 |
20664 | 20664 | 2020-03-30 | Marion | Mississippi | 28091 | 4 | 0 |
22781 | 22781 | 2020-03-31 | Marion | Mississippi | 28091 | 5 | 0 |
27219 | 27219 | 2020-04-02 | Marion | Mississippi | 28091 | 5 | 0 |
29538 | 29538 | 2020-04-03 | Marion | Mississippi | 28091 | 5 | 0 |
24965 | 24965 | 2020-04-01 | Marion | Mississippi | 28091 | 6 | 0 |
31918 | 31918 | 2020-04-04 | Marion | Mississippi | 28091 | 6 | 0 |
34345 | 34345 | 2020-04-05 | Marion | Mississippi | 28091 | 7 | 0 |
36808 | 36808 | 2020-04-06 | Marion | Mississippi | 28091 | 8 | 0 |
39319 | 39319 | 2020-04-07 | Marion | Mississippi | 28091 | 13 | 0 |
41873 | 41873 | 2020-04-08 | Marion | Mississippi | 28091 | 14 | 0 |
44450 | 44450 | 2020-04-09 | Marion | Mississippi | 28091 | 16 | 0 |
47059 | 47059 | 2020-04-10 | Marion | Mississippi | 28091 | 17 | 0 |
49705 | 49705 | 2020-04-11 | Marion | Mississippi | 28091 | 17 | 0 |
52378 | 52378 | 2020-04-12 | Marion | Mississippi | 28091 | 21 | 0 |
55060 | 55060 | 2020-04-13 | Marion | Mississippi | 28091 | 21 | 0 |
57758 | 57758 | 2020-04-14 | Marion | Mississippi | 28091 | 25 | 0 |
60469 | 60469 | 2020-04-15 | Marion | Mississippi | 28091 | 34 | 0 |
63191 | 63191 | 2020-04-16 | Marion | Mississippi | 28091 | 35 | 0 |
65931 | 65931 | 2020-04-17 | Marion | Mississippi | 28091 | 38 | 0 |
68683 | 68683 | 2020-04-18 | Marion | Mississippi | 28091 | 39 | 0 |
71449 | 71449 | 2020-04-19 | Marion | Mississippi | 28091 | 43 | 1 |
74222 | 74222 | 2020-04-20 | Marion | Mississippi | 28091 | 47 | 1 |
77003 | 77003 | 2020-04-21 | Marion | Mississippi | 28091 | 47 | 1 |
79788 | 79788 | 2020-04-22 | Marion | Mississippi | 28091 | 48 | 2 |
82584 | 82584 | 2020-04-23 | Marion | Mississippi | 28091 | 53 | 4 |
85388 | 85388 | 2020-04-24 | Marion | Mississippi | 28091 | 55 | 4 |
88198 | 88198 | 2020-04-25 | Marion | Mississippi | 28091 | 57 | 5 |
91014 | 91014 | 2020-04-26 | Marion | Mississippi | 28091 | 58 | 5 |
93835 | 93835 | 2020-04-27 | Marion | Mississippi | 28091 | 58 | 5 |
96671 | 96671 | 2020-04-28 | Marion | Mississippi | 28091 | 66 | 5 |
99517 | 99517 | 2020-04-29 | Marion | Mississippi | 28091 | 69 | 5 |
102369 | 102369 | 2020-04-30 | Marion | Mississippi | 28091 | 72 | 6 |
105230 | 105230 | 2020-05-01 | Marion | Mississippi | 28091 | 75 | 7 |
108095 | 108095 | 2020-05-02 | Marion | Mississippi | 28091 | 75 | 7 |
110966 | 110966 | 2020-05-03 | Marion | Mississippi | 28091 | 75 | 7 |
113845 | 113845 | 2020-05-04 | Marion | Mississippi | 28091 | 75 | 7 |
116727 | 116727 | 2020-05-05 | Marion | Mississippi | 28091 | 76 | 7 |
119687 | 119687 | 2020-05-06 | Marion | Mississippi | 28091 | 77 | 7 |
122661 | 122661 | 2020-05-07 | Marion | Mississippi | 28091 | 80 | 7 |
131620 | 131620 | 2020-05-10 | Marion | Mississippi | 28091 | 81 | 7 |
125643 | 125643 | 2020-05-08 | Marion | Mississippi | 28091 | 82 | 7 |
128630 | 128630 | 2020-05-09 | Marion | Mississippi | 28091 | 83 | 7 |
134611 | 134611 | 2020-05-11 | Marion | Mississippi | 28091 | 84 | 7 |
137601 | 137601 | 2020-05-12 | Marion | Mississippi | 28091 | 84 | 7 |
140595 | 140595 | 2020-05-13 | Marion | Mississippi | 28091 | 86 | 7 |
143590 | 143590 | 2020-05-14 | Marion | Mississippi | 28091 | 86 | 7 |
146590 | 146590 | 2020-05-15 | Marion | Mississippi | 28091 | 86 | 7 |
149595 | 149595 | 2020-05-16 | Marion | Mississippi | 28091 | 87 | 7 |
152606 | 152606 | 2020-05-17 | Marion | Mississippi | 28091 | 89 | 8 |
155620 | 155620 | 2020-05-18 | Marion | Mississippi | 28091 | 89 | 8 |
158638 | 158638 | 2020-05-19 | Marion | Mississippi | 28091 | 93 | 8 |
161664 | 161664 | 2020-05-20 | Marion | Mississippi | 28091 | 97 | 8 |
164693 | 164693 | 2020-05-21 | Marion | Mississippi | 28091 | 100 | 8 |
167729 | 167729 | 2020-05-22 | Marion | Mississippi | 28091 | 103 | 8 |
170767 | 170767 | 2020-05-23 | Marion | Mississippi | 28091 | 104 | 8 |
173809 | 173809 | 2020-05-24 | Marion | Mississippi | 28091 | 108 | 8 |
176852 | 176852 | 2020-05-25 | Marion | Mississippi | 28091 | 110 | 8 |
179896 | 179896 | 2020-05-26 | Marion | Mississippi | 28091 | 110 | 9 |
182942 | 182942 | 2020-05-27 | Marion | Mississippi | 28091 | 112 | 9 |
185998 | 185998 | 2020-05-28 | Marion | Mississippi | 28091 | 114 | 9 |
189056 | 189056 | 2020-05-29 | Marion | Mississippi | 28091 | 114 | 9 |
195188 | 195188 | 2020-05-31 | Marion | Mississippi | 28091 | 114 | 9 |
192120 | 192120 | 2020-05-30 | Marion | Mississippi | 28091 | 115 | 9 |
201332 | 201332 | 2020-06-02 | Marion | Mississippi | 28091 | 115 | 9 |
204409 | 204409 | 2020-06-03 | Marion | Mississippi | 28091 | 116 | 9 |
207490 | 207490 | 2020-06-04 | Marion | Mississippi | 28091 | 116 | 9 |
210571 | 210571 | 2020-06-05 | Marion | Mississippi | 28091 | 116 | 9 |
198259 | 198259 | 2020-06-01 | Marion | Mississippi | 28091 | 117 | 9 |
213655 | 213655 | 2020-06-06 | Marion | Mississippi | 28091 | 117 | 9 |
216743 | 216743 | 2020-06-07 | Marion | Mississippi | 28091 | 119 | 9 |
219835 | 219835 | 2020-06-08 | Marion | Mississippi | 28091 | 127 | 9 |
222930 | 222930 | 2020-06-09 | Marion | Mississippi | 28091 | 129 | 9 |
226028 | 226028 | 2020-06-10 | Marion | Mississippi | 28091 | 132 | 9 |
229130 | 229130 | 2020-06-11 | Marion | Mississippi | 28091 | 132 | 9 |
232234 | 232234 | 2020-06-12 | Marion | Mississippi | 28091 | 137 | 9 |
235340 | 235340 | 2020-06-13 | Marion | Mississippi | 28091 | 140 | 9 |
238447 | 238447 | 2020-06-14 | Marion | Mississippi | 28091 | 141 | 9 |
241556 | 241556 | 2020-06-15 | Marion | Mississippi | 28091 | 145 | 9 |
244667 | 244667 | 2020-06-16 | Marion | Mississippi | 28091 | 152 | 9 |
247780 | 247780 | 2020-06-17 | Marion | Mississippi | 28091 | 163 | 9 |
250892 | 250892 | 2020-06-18 | Marion | Mississippi | 28091 | 163 | 9 |
254007 | 254007 | 2020-06-19 | Marion | Mississippi | 28091 | 163 | 9 |
257127 | 257127 | 2020-06-20 | Marion | Mississippi | 28091 | 163 | 9 |
260253 | 260253 | 2020-06-21 | Marion | Mississippi | 28091 | 163 | 9 |
263382 | 263382 | 2020-06-22 | Marion | Mississippi | 28091 | 186 | 10 |
266508 | 266508 | 2020-06-23 | Marion | Mississippi | 28091 | 196 | 10 |
269641 | 269641 | 2020-06-24 | Marion | Mississippi | 28091 | 203 | 10 |
272779 | 272779 | 2020-06-25 | Marion | Mississippi | 28091 | 215 | 10 |
275922 | 275922 | 2020-06-26 | Marion | Mississippi | 28091 | 223 | 11 |
279070 | 279070 | 2020-06-27 | Marion | Mississippi | 28091 | 225 | 11 |
282218 | 282218 | 2020-06-28 | Marion | Mississippi | 28091 | 228 | 11 |
285363 | 285363 | 2020-06-29 | Marion | Mississippi | 28091 | 233 | 11 |
288513 | 288513 | 2020-06-30 | Marion | Mississippi | 28091 | 240 | 11 |
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);