ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,553 rows where county = "Atchison" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
20302 | 20302 | 2020-03-30 | Atchison | Kansas | 20005 | 1 | 0 |
22398 | 22398 | 2020-03-31 | Atchison | Kansas | 20005 | 1 | 0 |
24573 | 24573 | 2020-04-01 | Atchison | Kansas | 20005 | 1 | 0 |
26815 | 26815 | 2020-04-02 | Atchison | Kansas | 20005 | 1 | 0 |
29129 | 29129 | 2020-04-03 | Atchison | Kansas | 20005 | 1 | 0 |
31501 | 31501 | 2020-04-04 | Atchison | Kansas | 20005 | 2 | 0 |
33914 | 33914 | 2020-04-05 | Atchison | Kansas | 20005 | 2 | 0 |
36371 | 36371 | 2020-04-06 | Atchison | Kansas | 20005 | 2 | 0 |
38872 | 38872 | 2020-04-07 | Atchison | Kansas | 20005 | 2 | 0 |
41419 | 41419 | 2020-04-08 | Atchison | Kansas | 20005 | 2 | 0 |
43995 | 43995 | 2020-04-09 | Atchison | Kansas | 20005 | 2 | 0 |
46602 | 46602 | 2020-04-10 | Atchison | Kansas | 20005 | 2 | 0 |
49236 | 49236 | 2020-04-11 | Atchison | Kansas | 20005 | 3 | 0 |
51900 | 51900 | 2020-04-12 | Atchison | Kansas | 20005 | 3 | 0 |
54582 | 54582 | 2020-04-13 | Atchison | Kansas | 20005 | 3 | 0 |
57275 | 57275 | 2020-04-14 | Atchison | Kansas | 20005 | 3 | 0 |
59983 | 59983 | 2020-04-15 | Atchison | Kansas | 20005 | 3 | 0 |
62704 | 62704 | 2020-04-16 | Atchison | Kansas | 20005 | 3 | 0 |
65439 | 65439 | 2020-04-17 | Atchison | Kansas | 20005 | 4 | 0 |
68188 | 68188 | 2020-04-18 | Atchison | Kansas | 20005 | 4 | 0 |
70949 | 70949 | 2020-04-19 | Atchison | Kansas | 20005 | 5 | 0 |
73720 | 73720 | 2020-04-20 | Atchison | Kansas | 20005 | 6 | 0 |
76500 | 76500 | 2020-04-21 | Atchison | Kansas | 20005 | 6 | 0 |
79284 | 79284 | 2020-04-22 | Atchison | Kansas | 20005 | 6 | 0 |
82076 | 82076 | 2020-04-23 | Atchison | Kansas | 20005 | 8 | 0 |
84877 | 84877 | 2020-04-24 | Atchison | Kansas | 20005 | 8 | 0 |
87686 | 87686 | 2020-04-25 | Atchison | Kansas | 20005 | 8 | 0 |
90502 | 90502 | 2020-04-26 | Atchison | Kansas | 20005 | 9 | 0 |
93323 | 93323 | 2020-04-27 | Atchison | Kansas | 20005 | 9 | 0 |
96155 | 96155 | 2020-04-28 | Atchison | Kansas | 20005 | 9 | 0 |
99000 | 99000 | 2020-04-29 | Atchison | Kansas | 20005 | 9 | 0 |
101851 | 101851 | 2020-04-30 | Atchison | Kansas | 20005 | 9 | 0 |
104711 | 104711 | 2020-05-01 | Atchison | Kansas | 20005 | 10 | 0 |
107576 | 107576 | 2020-05-02 | Atchison | Kansas | 20005 | 10 | 0 |
110447 | 110447 | 2020-05-03 | Atchison | Kansas | 20005 | 11 | 0 |
113322 | 113322 | 2020-05-04 | Atchison | Kansas | 20005 | 11 | 0 |
116204 | 116204 | 2020-05-05 | Atchison | Kansas | 20005 | 12 | 0 |
119165 | 119165 | 2020-05-06 | Atchison | Kansas | 20005 | 12 | 0 |
122135 | 122135 | 2020-05-07 | Atchison | Kansas | 20005 | 12 | 0 |
125117 | 125117 | 2020-05-08 | Atchison | Kansas | 20005 | 12 | 0 |
128105 | 128105 | 2020-05-09 | Atchison | Kansas | 20005 | 12 | 0 |
131095 | 131095 | 2020-05-10 | Atchison | Kansas | 20005 | 13 | 0 |
134086 | 134086 | 2020-05-11 | Atchison | Kansas | 20005 | 14 | 0 |
137076 | 137076 | 2020-05-12 | Atchison | Kansas | 20005 | 14 | 0 |
140069 | 140069 | 2020-05-13 | Atchison | Kansas | 20005 | 15 | 0 |
143065 | 143065 | 2020-05-14 | Atchison | Kansas | 20005 | 15 | 0 |
146065 | 146065 | 2020-05-15 | Atchison | Kansas | 20005 | 15 | 0 |
149069 | 149069 | 2020-05-16 | Atchison | Kansas | 20005 | 15 | 0 |
152080 | 152080 | 2020-05-17 | Atchison | Kansas | 20005 | 15 | 0 |
155092 | 155092 | 2020-05-18 | Atchison | Kansas | 20005 | 15 | 0 |
158109 | 158109 | 2020-05-19 | Atchison | Kansas | 20005 | 15 | 0 |
161134 | 161134 | 2020-05-20 | Atchison | Kansas | 20005 | 15 | 0 |
164163 | 164163 | 2020-05-21 | Atchison | Kansas | 20005 | 15 | 0 |
167195 | 167195 | 2020-05-22 | Atchison | Kansas | 20005 | 17 | 0 |
170233 | 170233 | 2020-05-23 | Atchison | Kansas | 20005 | 17 | 0 |
173274 | 173274 | 2020-05-24 | Atchison | Kansas | 20005 | 17 | 0 |
176318 | 176318 | 2020-05-25 | Atchison | Kansas | 20005 | 20 | 0 |
179362 | 179362 | 2020-05-26 | Atchison | Kansas | 20005 | 20 | 0 |
182407 | 182407 | 2020-05-27 | Atchison | Kansas | 20005 | 20 | 0 |
185461 | 185461 | 2020-05-28 | Atchison | Kansas | 20005 | 20 | 0 |
188519 | 188519 | 2020-05-29 | Atchison | Kansas | 20005 | 20 | 0 |
191583 | 191583 | 2020-05-30 | Atchison | Kansas | 20005 | 20 | 0 |
194651 | 194651 | 2020-05-31 | Atchison | Kansas | 20005 | 20 | 0 |
197721 | 197721 | 2020-06-01 | Atchison | Kansas | 20005 | 22 | 0 |
200793 | 200793 | 2020-06-02 | Atchison | Kansas | 20005 | 22 | 0 |
203869 | 203869 | 2020-06-03 | Atchison | Kansas | 20005 | 22 | 0 |
206950 | 206950 | 2020-06-04 | Atchison | Kansas | 20005 | 22 | 0 |
210031 | 210031 | 2020-06-05 | Atchison | Kansas | 20005 | 23 | 0 |
213116 | 213116 | 2020-06-06 | Atchison | Kansas | 20005 | 23 | 0 |
216203 | 216203 | 2020-06-07 | Atchison | Kansas | 20005 | 23 | 0 |
219295 | 219295 | 2020-06-08 | Atchison | Kansas | 20005 | 23 | 0 |
222390 | 222390 | 2020-06-09 | Atchison | Kansas | 20005 | 23 | 0 |
225485 | 225485 | 2020-06-10 | Atchison | Kansas | 20005 | 24 | 0 |
228587 | 228587 | 2020-06-11 | Atchison | Kansas | 20005 | 24 | 0 |
231690 | 231690 | 2020-06-12 | Atchison | Kansas | 20005 | 25 | 0 |
234796 | 234796 | 2020-06-13 | Atchison | Kansas | 20005 | 25 | 0 |
237903 | 237903 | 2020-06-14 | Atchison | Kansas | 20005 | 26 | 0 |
241012 | 241012 | 2020-06-15 | Atchison | Kansas | 20005 | 26 | 0 |
244123 | 244123 | 2020-06-16 | Atchison | Kansas | 20005 | 26 | 0 |
247236 | 247236 | 2020-06-17 | Atchison | Kansas | 20005 | 26 | 0 |
250348 | 250348 | 2020-06-18 | Atchison | Kansas | 20005 | 26 | 0 |
253463 | 253463 | 2020-06-19 | Atchison | Kansas | 20005 | 26 | 0 |
256583 | 256583 | 2020-06-20 | Atchison | Kansas | 20005 | 26 | 0 |
259709 | 259709 | 2020-06-21 | Atchison | Kansas | 20005 | 26 | 0 |
262836 | 262836 | 2020-06-22 | Atchison | Kansas | 20005 | 27 | 0 |
265964 | 265964 | 2020-06-23 | Atchison | Kansas | 20005 | 27 | 0 |
269094 | 269094 | 2020-06-24 | Atchison | Kansas | 20005 | 27 | 0 |
272231 | 272231 | 2020-06-25 | Atchison | Kansas | 20005 | 27 | 0 |
275373 | 275373 | 2020-06-26 | Atchison | Kansas | 20005 | 27 | 0 |
278521 | 278521 | 2020-06-27 | Atchison | Kansas | 20005 | 27 | 0 |
281669 | 281669 | 2020-06-28 | Atchison | Kansas | 20005 | 27 | 0 |
284814 | 284814 | 2020-06-29 | Atchison | Kansas | 20005 | 32 | 0 |
287963 | 287963 | 2020-06-30 | Atchison | Kansas | 20005 | 32 | 0 |
291113 | 291113 | 2020-07-01 | Atchison | Kansas | 20005 | 34 | 0 |
294267 | 294267 | 2020-07-02 | Atchison | Kansas | 20005 | 34 | 0 |
297425 | 297425 | 2020-07-03 | Atchison | Kansas | 20005 | 38 | 0 |
300587 | 300587 | 2020-07-04 | Atchison | Kansas | 20005 | 38 | 0 |
303751 | 303751 | 2020-07-05 | Atchison | Kansas | 20005 | 38 | 0 |
306916 | 306916 | 2020-07-06 | Atchison | Kansas | 20005 | 40 | 0 |
310084 | 310084 | 2020-07-07 | Atchison | Kansas | 20005 | 40 | 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);