ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Marion" and fips = 20115 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
29154 | 29154 | 2020-04-03 | Marion | Kansas | 20115 | 1 | 0 |
31528 | 31528 | 2020-04-04 | Marion | Kansas | 20115 | 2 | 0 |
33942 | 33942 | 2020-04-05 | Marion | Kansas | 20115 | 2 | 0 |
36399 | 36399 | 2020-04-06 | Marion | Kansas | 20115 | 3 | 0 |
38901 | 38901 | 2020-04-07 | Marion | Kansas | 20115 | 3 | 0 |
41448 | 41448 | 2020-04-08 | Marion | Kansas | 20115 | 3 | 0 |
44024 | 44024 | 2020-04-09 | Marion | Kansas | 20115 | 3 | 0 |
46631 | 46631 | 2020-04-10 | Marion | Kansas | 20115 | 3 | 0 |
49267 | 49267 | 2020-04-11 | Marion | Kansas | 20115 | 3 | 0 |
51932 | 51932 | 2020-04-12 | Marion | Kansas | 20115 | 3 | 0 |
54614 | 54614 | 2020-04-13 | Marion | Kansas | 20115 | 4 | 0 |
57308 | 57308 | 2020-04-14 | Marion | Kansas | 20115 | 5 | 0 |
60016 | 60016 | 2020-04-15 | Marion | Kansas | 20115 | 5 | 0 |
62737 | 62737 | 2020-04-16 | Marion | Kansas | 20115 | 5 | 0 |
65473 | 65473 | 2020-04-17 | Marion | Kansas | 20115 | 5 | 0 |
68222 | 68222 | 2020-04-18 | Marion | Kansas | 20115 | 5 | 0 |
70983 | 70983 | 2020-04-19 | Marion | Kansas | 20115 | 5 | 0 |
73755 | 73755 | 2020-04-20 | Marion | Kansas | 20115 | 5 | 0 |
76535 | 76535 | 2020-04-21 | Marion | Kansas | 20115 | 5 | 0 |
79320 | 79320 | 2020-04-22 | Marion | Kansas | 20115 | 5 | 0 |
82115 | 82115 | 2020-04-23 | Marion | Kansas | 20115 | 5 | 0 |
84917 | 84917 | 2020-04-24 | Marion | Kansas | 20115 | 5 | 0 |
87726 | 87726 | 2020-04-25 | Marion | Kansas | 20115 | 5 | 0 |
90542 | 90542 | 2020-04-26 | Marion | Kansas | 20115 | 5 | 0 |
93363 | 93363 | 2020-04-27 | Marion | Kansas | 20115 | 5 | 1 |
96195 | 96195 | 2020-04-28 | Marion | Kansas | 20115 | 5 | 1 |
99041 | 99041 | 2020-04-29 | Marion | Kansas | 20115 | 5 | 1 |
101893 | 101893 | 2020-04-30 | Marion | Kansas | 20115 | 5 | 1 |
104753 | 104753 | 2020-05-01 | Marion | Kansas | 20115 | 5 | 1 |
107618 | 107618 | 2020-05-02 | Marion | Kansas | 20115 | 5 | 1 |
110489 | 110489 | 2020-05-03 | Marion | Kansas | 20115 | 5 | 1 |
113366 | 113366 | 2020-05-04 | Marion | Kansas | 20115 | 5 | 1 |
116248 | 116248 | 2020-05-05 | Marion | Kansas | 20115 | 5 | 1 |
119209 | 119209 | 2020-05-06 | Marion | Kansas | 20115 | 5 | 1 |
122179 | 122179 | 2020-05-07 | Marion | Kansas | 20115 | 6 | 1 |
125161 | 125161 | 2020-05-08 | Marion | Kansas | 20115 | 6 | 1 |
128149 | 128149 | 2020-05-09 | Marion | Kansas | 20115 | 6 | 1 |
131139 | 131139 | 2020-05-10 | Marion | Kansas | 20115 | 6 | 1 |
134130 | 134130 | 2020-05-11 | Marion | Kansas | 20115 | 7 | 1 |
137120 | 137120 | 2020-05-12 | Marion | Kansas | 20115 | 7 | 1 |
140113 | 140113 | 2020-05-13 | Marion | Kansas | 20115 | 7 | 1 |
143109 | 143109 | 2020-05-14 | Marion | Kansas | 20115 | 7 | 1 |
146109 | 146109 | 2020-05-15 | Marion | Kansas | 20115 | 7 | 1 |
149113 | 149113 | 2020-05-16 | Marion | Kansas | 20115 | 7 | 1 |
152124 | 152124 | 2020-05-17 | Marion | Kansas | 20115 | 7 | 1 |
155136 | 155136 | 2020-05-18 | Marion | Kansas | 20115 | 7 | 1 |
158153 | 158153 | 2020-05-19 | Marion | Kansas | 20115 | 7 | 1 |
167242 | 167242 | 2020-05-22 | Marion | Kansas | 20115 | 7 | 1 |
170280 | 170280 | 2020-05-23 | Marion | Kansas | 20115 | 7 | 1 |
173321 | 173321 | 2020-05-24 | Marion | Kansas | 20115 | 7 | 1 |
176365 | 176365 | 2020-05-25 | Marion | Kansas | 20115 | 7 | 1 |
179409 | 179409 | 2020-05-26 | Marion | Kansas | 20115 | 7 | 1 |
182454 | 182454 | 2020-05-27 | Marion | Kansas | 20115 | 7 | 1 |
185508 | 185508 | 2020-05-28 | Marion | Kansas | 20115 | 7 | 1 |
188566 | 188566 | 2020-05-29 | Marion | Kansas | 20115 | 7 | 1 |
191630 | 191630 | 2020-05-30 | Marion | Kansas | 20115 | 7 | 1 |
194698 | 194698 | 2020-05-31 | Marion | Kansas | 20115 | 7 | 1 |
197768 | 197768 | 2020-06-01 | Marion | Kansas | 20115 | 7 | 1 |
200840 | 200840 | 2020-06-02 | Marion | Kansas | 20115 | 7 | 1 |
203916 | 203916 | 2020-06-03 | Marion | Kansas | 20115 | 7 | 1 |
206997 | 206997 | 2020-06-04 | Marion | Kansas | 20115 | 7 | 1 |
210078 | 210078 | 2020-06-05 | Marion | Kansas | 20115 | 7 | 1 |
213163 | 213163 | 2020-06-06 | Marion | Kansas | 20115 | 7 | 1 |
216250 | 216250 | 2020-06-07 | Marion | Kansas | 20115 | 7 | 1 |
219342 | 219342 | 2020-06-08 | Marion | Kansas | 20115 | 7 | 1 |
222437 | 222437 | 2020-06-09 | Marion | Kansas | 20115 | 7 | 1 |
225532 | 225532 | 2020-06-10 | Marion | Kansas | 20115 | 7 | 1 |
228634 | 228634 | 2020-06-11 | Marion | Kansas | 20115 | 7 | 1 |
231737 | 231737 | 2020-06-12 | Marion | Kansas | 20115 | 7 | 1 |
234843 | 234843 | 2020-06-13 | Marion | Kansas | 20115 | 7 | 1 |
237950 | 237950 | 2020-06-14 | Marion | Kansas | 20115 | 7 | 1 |
241059 | 241059 | 2020-06-15 | Marion | Kansas | 20115 | 7 | 1 |
244170 | 244170 | 2020-06-16 | Marion | Kansas | 20115 | 7 | 1 |
247283 | 247283 | 2020-06-17 | Marion | Kansas | 20115 | 7 | 1 |
250395 | 250395 | 2020-06-18 | Marion | Kansas | 20115 | 7 | 1 |
253510 | 253510 | 2020-06-19 | Marion | Kansas | 20115 | 7 | 1 |
256630 | 256630 | 2020-06-20 | Marion | Kansas | 20115 | 7 | 1 |
259756 | 259756 | 2020-06-21 | Marion | Kansas | 20115 | 7 | 1 |
161178 | 161178 | 2020-05-20 | Marion | Kansas | 20115 | 8 | 1 |
164207 | 164207 | 2020-05-21 | Marion | Kansas | 20115 | 8 | 1 |
262883 | 262883 | 2020-06-22 | Marion | Kansas | 20115 | 9 | 1 |
266011 | 266011 | 2020-06-23 | Marion | Kansas | 20115 | 9 | 1 |
269142 | 269142 | 2020-06-24 | Marion | Kansas | 20115 | 9 | 1 |
272279 | 272279 | 2020-06-25 | Marion | Kansas | 20115 | 9 | 1 |
275422 | 275422 | 2020-06-26 | Marion | Kansas | 20115 | 10 | 1 |
278570 | 278570 | 2020-06-27 | Marion | Kansas | 20115 | 10 | 1 |
281718 | 281718 | 2020-06-28 | Marion | Kansas | 20115 | 10 | 1 |
284863 | 284863 | 2020-06-29 | Marion | Kansas | 20115 | 11 | 1 |
288012 | 288012 | 2020-06-30 | Marion | Kansas | 20115 | 11 | 1 |
291162 | 291162 | 2020-07-01 | Marion | Kansas | 20115 | 11 | 1 |
294316 | 294316 | 2020-07-02 | Marion | Kansas | 20115 | 11 | 1 |
297474 | 297474 | 2020-07-03 | Marion | Kansas | 20115 | 12 | 1 |
300636 | 300636 | 2020-07-04 | Marion | Kansas | 20115 | 12 | 1 |
303800 | 303800 | 2020-07-05 | Marion | Kansas | 20115 | 12 | 1 |
306967 | 306967 | 2020-07-06 | Marion | Kansas | 20115 | 12 | 1 |
310135 | 310135 | 2020-07-07 | Marion | Kansas | 20115 | 12 | 1 |
313305 | 313305 | 2020-07-08 | Marion | Kansas | 20115 | 15 | 1 |
316479 | 316479 | 2020-07-09 | Marion | Kansas | 20115 | 15 | 1 |
319653 | 319653 | 2020-07-10 | Marion | Kansas | 20115 | 22 | 1 |
322832 | 322832 | 2020-07-11 | Marion | Kansas | 20115 | 22 | 1 |
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);