ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,476 rows where county = "Barton" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22399 | 22399 | 2020-03-31 | Barton | Kansas | 20009 | 1 | 0 |
24574 | 24574 | 2020-04-01 | Barton | Kansas | 20009 | 2 | 0 |
26816 | 26816 | 2020-04-02 | Barton | Kansas | 20009 | 2 | 0 |
29130 | 29130 | 2020-04-03 | Barton | Kansas | 20009 | 3 | 0 |
31502 | 31502 | 2020-04-04 | Barton | Kansas | 20009 | 3 | 0 |
33915 | 33915 | 2020-04-05 | Barton | Kansas | 20009 | 3 | 0 |
36372 | 36372 | 2020-04-06 | Barton | Kansas | 20009 | 3 | 0 |
38874 | 38874 | 2020-04-07 | Barton | Kansas | 20009 | 3 | 0 |
41421 | 41421 | 2020-04-08 | Barton | Kansas | 20009 | 4 | 0 |
43997 | 43997 | 2020-04-09 | Barton | Kansas | 20009 | 4 | 0 |
46604 | 46604 | 2020-04-10 | Barton | Kansas | 20009 | 4 | 0 |
49238 | 49238 | 2020-04-11 | Barton | Kansas | 20009 | 5 | 0 |
51902 | 51902 | 2020-04-12 | Barton | Kansas | 20009 | 5 | 0 |
54584 | 54584 | 2020-04-13 | Barton | Kansas | 20009 | 5 | 0 |
57277 | 57277 | 2020-04-14 | Barton | Kansas | 20009 | 5 | 0 |
59985 | 59985 | 2020-04-15 | Barton | Kansas | 20009 | 5 | 0 |
62706 | 62706 | 2020-04-16 | Barton | Kansas | 20009 | 5 | 0 |
65441 | 65441 | 2020-04-17 | Barton | Kansas | 20009 | 5 | 0 |
68190 | 68190 | 2020-04-18 | Barton | Kansas | 20009 | 6 | 0 |
70951 | 70951 | 2020-04-19 | Barton | Kansas | 20009 | 6 | 0 |
73722 | 73722 | 2020-04-20 | Barton | Kansas | 20009 | 7 | 0 |
76502 | 76502 | 2020-04-21 | Barton | Kansas | 20009 | 8 | 0 |
79286 | 79286 | 2020-04-22 | Barton | Kansas | 20009 | 8 | 0 |
82078 | 82078 | 2020-04-23 | Barton | Kansas | 20009 | 9 | 0 |
84879 | 84879 | 2020-04-24 | Barton | Kansas | 20009 | 9 | 0 |
87688 | 87688 | 2020-04-25 | Barton | Kansas | 20009 | 9 | 0 |
90504 | 90504 | 2020-04-26 | Barton | Kansas | 20009 | 9 | 0 |
93325 | 93325 | 2020-04-27 | Barton | Kansas | 20009 | 9 | 0 |
96157 | 96157 | 2020-04-28 | Barton | Kansas | 20009 | 9 | 0 |
99002 | 99002 | 2020-04-29 | Barton | Kansas | 20009 | 9 | 0 |
101853 | 101853 | 2020-04-30 | Barton | Kansas | 20009 | 9 | 0 |
104713 | 104713 | 2020-05-01 | Barton | Kansas | 20009 | 9 | 0 |
107578 | 107578 | 2020-05-02 | Barton | Kansas | 20009 | 9 | 0 |
110449 | 110449 | 2020-05-03 | Barton | Kansas | 20009 | 9 | 0 |
113324 | 113324 | 2020-05-04 | Barton | Kansas | 20009 | 9 | 0 |
116206 | 116206 | 2020-05-05 | Barton | Kansas | 20009 | 9 | 0 |
119167 | 119167 | 2020-05-06 | Barton | Kansas | 20009 | 9 | 1 |
122137 | 122137 | 2020-05-07 | Barton | Kansas | 20009 | 10 | 1 |
125119 | 125119 | 2020-05-08 | Barton | Kansas | 20009 | 14 | 1 |
128107 | 128107 | 2020-05-09 | Barton | Kansas | 20009 | 19 | 1 |
131097 | 131097 | 2020-05-10 | Barton | Kansas | 20009 | 21 | 1 |
134088 | 134088 | 2020-05-11 | Barton | Kansas | 20009 | 22 | 1 |
137078 | 137078 | 2020-05-12 | Barton | Kansas | 20009 | 23 | 1 |
140071 | 140071 | 2020-05-13 | Barton | Kansas | 20009 | 23 | 1 |
143067 | 143067 | 2020-05-14 | Barton | Kansas | 20009 | 28 | 1 |
146067 | 146067 | 2020-05-15 | Barton | Kansas | 20009 | 28 | 1 |
149071 | 149071 | 2020-05-16 | Barton | Kansas | 20009 | 30 | 1 |
152082 | 152082 | 2020-05-17 | Barton | Kansas | 20009 | 31 | 1 |
155094 | 155094 | 2020-05-18 | Barton | Kansas | 20009 | 31 | 1 |
158111 | 158111 | 2020-05-19 | Barton | Kansas | 20009 | 31 | 1 |
161136 | 161136 | 2020-05-20 | Barton | Kansas | 20009 | 32 | 1 |
164165 | 164165 | 2020-05-21 | Barton | Kansas | 20009 | 32 | 1 |
167197 | 167197 | 2020-05-22 | Barton | Kansas | 20009 | 36 | 1 |
170235 | 170235 | 2020-05-23 | Barton | Kansas | 20009 | 45 | 1 |
173276 | 173276 | 2020-05-24 | Barton | Kansas | 20009 | 45 | 1 |
176320 | 176320 | 2020-05-25 | Barton | Kansas | 20009 | 45 | 1 |
179364 | 179364 | 2020-05-26 | Barton | Kansas | 20009 | 45 | 1 |
182409 | 182409 | 2020-05-27 | Barton | Kansas | 20009 | 45 | 1 |
185463 | 185463 | 2020-05-28 | Barton | Kansas | 20009 | 45 | 1 |
188521 | 188521 | 2020-05-29 | Barton | Kansas | 20009 | 45 | 1 |
191585 | 191585 | 2020-05-30 | Barton | Kansas | 20009 | 45 | 1 |
194653 | 194653 | 2020-05-31 | Barton | Kansas | 20009 | 45 | 1 |
197723 | 197723 | 2020-06-01 | Barton | Kansas | 20009 | 44 | 1 |
200795 | 200795 | 2020-06-02 | Barton | Kansas | 20009 | 44 | 1 |
203871 | 203871 | 2020-06-03 | Barton | Kansas | 20009 | 44 | 1 |
206952 | 206952 | 2020-06-04 | Barton | Kansas | 20009 | 44 | 1 |
210033 | 210033 | 2020-06-05 | Barton | Kansas | 20009 | 44 | 2 |
213118 | 213118 | 2020-06-06 | Barton | Kansas | 20009 | 45 | 2 |
216205 | 216205 | 2020-06-07 | Barton | Kansas | 20009 | 45 | 2 |
219297 | 219297 | 2020-06-08 | Barton | Kansas | 20009 | 46 | 2 |
222392 | 222392 | 2020-06-09 | Barton | Kansas | 20009 | 47 | 2 |
225487 | 225487 | 2020-06-10 | Barton | Kansas | 20009 | 47 | 2 |
228589 | 228589 | 2020-06-11 | Barton | Kansas | 20009 | 47 | 2 |
229172 | 229172 | 2020-06-11 | Barton | Missouri | 29011 | 1 | 0 |
231692 | 231692 | 2020-06-12 | Barton | Kansas | 20009 | 48 | 2 |
232276 | 232276 | 2020-06-12 | Barton | Missouri | 29011 | 1 | 0 |
234798 | 234798 | 2020-06-13 | Barton | Kansas | 20009 | 48 | 2 |
235382 | 235382 | 2020-06-13 | Barton | Missouri | 29011 | 1 | 0 |
237905 | 237905 | 2020-06-14 | Barton | Kansas | 20009 | 48 | 2 |
238489 | 238489 | 2020-06-14 | Barton | Missouri | 29011 | 1 | 0 |
241014 | 241014 | 2020-06-15 | Barton | Kansas | 20009 | 49 | 2 |
241598 | 241598 | 2020-06-15 | Barton | Missouri | 29011 | 7 | 0 |
244125 | 244125 | 2020-06-16 | Barton | Kansas | 20009 | 49 | 2 |
244709 | 244709 | 2020-06-16 | Barton | Missouri | 29011 | 9 | 0 |
247238 | 247238 | 2020-06-17 | Barton | Kansas | 20009 | 51 | 2 |
247822 | 247822 | 2020-06-17 | Barton | Missouri | 29011 | 11 | 0 |
250350 | 250350 | 2020-06-18 | Barton | Kansas | 20009 | 51 | 2 |
250935 | 250935 | 2020-06-18 | Barton | Missouri | 29011 | 10 | 0 |
253465 | 253465 | 2020-06-19 | Barton | Kansas | 20009 | 52 | 2 |
254050 | 254050 | 2020-06-19 | Barton | Missouri | 29011 | 15 | 0 |
256585 | 256585 | 2020-06-20 | Barton | Kansas | 20009 | 52 | 2 |
257170 | 257170 | 2020-06-20 | Barton | Missouri | 29011 | 15 | 0 |
259711 | 259711 | 2020-06-21 | Barton | Kansas | 20009 | 54 | 2 |
260296 | 260296 | 2020-06-21 | Barton | Missouri | 29011 | 15 | 0 |
262838 | 262838 | 2020-06-22 | Barton | Kansas | 20009 | 54 | 2 |
263424 | 263424 | 2020-06-22 | Barton | Missouri | 29011 | 15 | 0 |
265966 | 265966 | 2020-06-23 | Barton | Kansas | 20009 | 54 | 2 |
266550 | 266550 | 2020-06-23 | Barton | Missouri | 29011 | 16 | 0 |
269096 | 269096 | 2020-06-24 | Barton | Kansas | 20009 | 54 | 2 |
269683 | 269683 | 2020-06-24 | Barton | Missouri | 29011 | 17 | 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);