ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,171 rows where county = "Edwards" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Edwards · 2,171 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79300 | 79300 | 2020-04-22 | Edwards | Kansas | 20047 | 1 | 0 |
82093 | 82093 | 2020-04-23 | Edwards | Kansas | 20047 | 1 | 0 |
84894 | 84894 | 2020-04-24 | Edwards | Kansas | 20047 | 1 | 0 |
87703 | 87703 | 2020-04-25 | Edwards | Kansas | 20047 | 1 | 0 |
90519 | 90519 | 2020-04-26 | Edwards | Kansas | 20047 | 1 | 0 |
93340 | 93340 | 2020-04-27 | Edwards | Kansas | 20047 | 2 | 0 |
96172 | 96172 | 2020-04-28 | Edwards | Kansas | 20047 | 2 | 0 |
99018 | 99018 | 2020-04-29 | Edwards | Kansas | 20047 | 3 | 0 |
101869 | 101869 | 2020-04-30 | Edwards | Kansas | 20047 | 3 | 0 |
104729 | 104729 | 2020-05-01 | Edwards | Kansas | 20047 | 4 | 0 |
107594 | 107594 | 2020-05-02 | Edwards | Kansas | 20047 | 4 | 0 |
110465 | 110465 | 2020-05-03 | Edwards | Kansas | 20047 | 4 | 0 |
113341 | 113341 | 2020-05-04 | Edwards | Kansas | 20047 | 4 | 0 |
116223 | 116223 | 2020-05-05 | Edwards | Kansas | 20047 | 4 | 0 |
119184 | 119184 | 2020-05-06 | Edwards | Kansas | 20047 | 4 | 0 |
122154 | 122154 | 2020-05-07 | Edwards | Kansas | 20047 | 4 | 0 |
125136 | 125136 | 2020-05-08 | Edwards | Kansas | 20047 | 4 | 0 |
128124 | 128124 | 2020-05-09 | Edwards | Kansas | 20047 | 4 | 0 |
131114 | 131114 | 2020-05-10 | Edwards | Kansas | 20047 | 4 | 0 |
134105 | 134105 | 2020-05-11 | Edwards | Kansas | 20047 | 4 | 0 |
137095 | 137095 | 2020-05-12 | Edwards | Kansas | 20047 | 4 | 0 |
139803 | 139803 | 2020-05-13 | Edwards | Illinois | 17047 | 2 | 0 |
140088 | 140088 | 2020-05-13 | Edwards | Kansas | 20047 | 4 | 0 |
142799 | 142799 | 2020-05-14 | Edwards | Illinois | 17047 | 2 | 0 |
143084 | 143084 | 2020-05-14 | Edwards | Kansas | 20047 | 4 | 0 |
145799 | 145799 | 2020-05-15 | Edwards | Illinois | 17047 | 2 | 0 |
146084 | 146084 | 2020-05-15 | Edwards | Kansas | 20047 | 4 | 0 |
148802 | 148802 | 2020-05-16 | Edwards | Illinois | 17047 | 2 | 0 |
149088 | 149088 | 2020-05-16 | Edwards | Kansas | 20047 | 4 | 0 |
151811 | 151811 | 2020-05-17 | Edwards | Illinois | 17047 | 2 | 0 |
152099 | 152099 | 2020-05-17 | Edwards | Kansas | 20047 | 4 | 0 |
154823 | 154823 | 2020-05-18 | Edwards | Illinois | 17047 | 2 | 0 |
155111 | 155111 | 2020-05-18 | Edwards | Kansas | 20047 | 5 | 0 |
157839 | 157839 | 2020-05-19 | Edwards | Illinois | 17047 | 2 | 0 |
158128 | 158128 | 2020-05-19 | Edwards | Kansas | 20047 | 5 | 0 |
160865 | 160865 | 2020-05-20 | Edwards | Illinois | 17047 | 2 | 0 |
161153 | 161153 | 2020-05-20 | Edwards | Kansas | 20047 | 5 | 0 |
163893 | 163893 | 2020-05-21 | Edwards | Illinois | 17047 | 2 | 0 |
164182 | 164182 | 2020-05-21 | Edwards | Kansas | 20047 | 5 | 0 |
166926 | 166926 | 2020-05-22 | Edwards | Illinois | 17047 | 2 | 0 |
167215 | 167215 | 2020-05-22 | Edwards | Kansas | 20047 | 5 | 0 |
169963 | 169963 | 2020-05-23 | Edwards | Illinois | 17047 | 2 | 0 |
170253 | 170253 | 2020-05-23 | Edwards | Kansas | 20047 | 5 | 0 |
173004 | 173004 | 2020-05-24 | Edwards | Illinois | 17047 | 2 | 0 |
173294 | 173294 | 2020-05-24 | Edwards | Kansas | 20047 | 5 | 0 |
176048 | 176048 | 2020-05-25 | Edwards | Illinois | 17047 | 2 | 0 |
176338 | 176338 | 2020-05-25 | Edwards | Kansas | 20047 | 5 | 0 |
179092 | 179092 | 2020-05-26 | Edwards | Illinois | 17047 | 2 | 0 |
179382 | 179382 | 2020-05-26 | Edwards | Kansas | 20047 | 5 | 0 |
182136 | 182136 | 2020-05-27 | Edwards | Illinois | 17047 | 2 | 0 |
182427 | 182427 | 2020-05-27 | Edwards | Kansas | 20047 | 5 | 0 |
185190 | 185190 | 2020-05-28 | Edwards | Illinois | 17047 | 2 | 0 |
185481 | 185481 | 2020-05-28 | Edwards | Kansas | 20047 | 5 | 0 |
188248 | 188248 | 2020-05-29 | Edwards | Illinois | 17047 | 2 | 0 |
188539 | 188539 | 2020-05-29 | Edwards | Kansas | 20047 | 5 | 0 |
191313 | 191313 | 2020-05-30 | Edwards | Illinois | 17047 | 2 | 0 |
191603 | 191603 | 2020-05-30 | Edwards | Kansas | 20047 | 5 | 0 |
194380 | 194380 | 2020-05-31 | Edwards | Illinois | 17047 | 2 | 0 |
194671 | 194671 | 2020-05-31 | Edwards | Kansas | 20047 | 5 | 0 |
197450 | 197450 | 2020-06-01 | Edwards | Illinois | 17047 | 2 | 0 |
197741 | 197741 | 2020-06-01 | Edwards | Kansas | 20047 | 5 | 0 |
200523 | 200523 | 2020-06-02 | Edwards | Illinois | 17047 | 2 | 0 |
200813 | 200813 | 2020-06-02 | Edwards | Kansas | 20047 | 5 | 0 |
203599 | 203599 | 2020-06-03 | Edwards | Illinois | 17047 | 2 | 0 |
203889 | 203889 | 2020-06-03 | Edwards | Kansas | 20047 | 5 | 0 |
206679 | 206679 | 2020-06-04 | Edwards | Illinois | 17047 | 2 | 0 |
206970 | 206970 | 2020-06-04 | Edwards | Kansas | 20047 | 5 | 0 |
209760 | 209760 | 2020-06-05 | Edwards | Illinois | 17047 | 2 | 0 |
210051 | 210051 | 2020-06-05 | Edwards | Kansas | 20047 | 5 | 0 |
212845 | 212845 | 2020-06-06 | Edwards | Illinois | 17047 | 2 | 0 |
213136 | 213136 | 2020-06-06 | Edwards | Kansas | 20047 | 5 | 0 |
215932 | 215932 | 2020-06-07 | Edwards | Illinois | 17047 | 2 | 0 |
216223 | 216223 | 2020-06-07 | Edwards | Kansas | 20047 | 5 | 0 |
219023 | 219023 | 2020-06-08 | Edwards | Illinois | 17047 | 2 | 0 |
219315 | 219315 | 2020-06-08 | Edwards | Kansas | 20047 | 5 | 0 |
222118 | 222118 | 2020-06-09 | Edwards | Illinois | 17047 | 2 | 0 |
222410 | 222410 | 2020-06-09 | Edwards | Kansas | 20047 | 5 | 0 |
225213 | 225213 | 2020-06-10 | Edwards | Illinois | 17047 | 2 | 0 |
225505 | 225505 | 2020-06-10 | Edwards | Kansas | 20047 | 5 | 0 |
228315 | 228315 | 2020-06-11 | Edwards | Illinois | 17047 | 2 | 0 |
228607 | 228607 | 2020-06-11 | Edwards | Kansas | 20047 | 5 | 0 |
231418 | 231418 | 2020-06-12 | Edwards | Illinois | 17047 | 2 | 0 |
231710 | 231710 | 2020-06-12 | Edwards | Kansas | 20047 | 5 | 0 |
234524 | 234524 | 2020-06-13 | Edwards | Illinois | 17047 | 2 | 0 |
234816 | 234816 | 2020-06-13 | Edwards | Kansas | 20047 | 5 | 0 |
237631 | 237631 | 2020-06-14 | Edwards | Illinois | 17047 | 2 | 0 |
237923 | 237923 | 2020-06-14 | Edwards | Kansas | 20047 | 5 | 0 |
240739 | 240739 | 2020-06-15 | Edwards | Illinois | 17047 | 2 | 0 |
241032 | 241032 | 2020-06-15 | Edwards | Kansas | 20047 | 5 | 0 |
243850 | 243850 | 2020-06-16 | Edwards | Illinois | 17047 | 2 | 0 |
244143 | 244143 | 2020-06-16 | Edwards | Kansas | 20047 | 5 | 0 |
246963 | 246963 | 2020-06-17 | Edwards | Illinois | 17047 | 2 | 0 |
247256 | 247256 | 2020-06-17 | Edwards | Kansas | 20047 | 5 | 0 |
250075 | 250075 | 2020-06-18 | Edwards | Illinois | 17047 | 2 | 0 |
250368 | 250368 | 2020-06-18 | Edwards | Kansas | 20047 | 5 | 0 |
253190 | 253190 | 2020-06-19 | Edwards | Illinois | 17047 | 2 | 0 |
253483 | 253483 | 2020-06-19 | Edwards | Kansas | 20047 | 6 | 0 |
256310 | 256310 | 2020-06-20 | Edwards | Illinois | 17047 | 2 | 0 |
256603 | 256603 | 2020-06-20 | Edwards | Kansas | 20047 | 6 | 0 |
259436 | 259436 | 2020-06-21 | Edwards | Illinois | 17047 | 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);