ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,562 rows where county = "Ford" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
139806 | 139806 | 2020-05-13 | Ford | Illinois | 17053 | 14 | 1 |
140092 | 140092 | 2020-05-13 | Ford | Kansas | 20057 | 1233 | 2 |
142802 | 142802 | 2020-05-14 | Ford | Illinois | 17053 | 15 | 1 |
143088 | 143088 | 2020-05-14 | Ford | Kansas | 20057 | 1233 | 2 |
145802 | 145802 | 2020-05-15 | Ford | Illinois | 17053 | 16 | 1 |
146088 | 146088 | 2020-05-15 | Ford | Kansas | 20057 | 1299 | 2 |
148805 | 148805 | 2020-05-16 | Ford | Illinois | 17053 | 17 | 1 |
149092 | 149092 | 2020-05-16 | Ford | Kansas | 20057 | 1299 | 2 |
151814 | 151814 | 2020-05-17 | Ford | Illinois | 17053 | 17 | 1 |
152103 | 152103 | 2020-05-17 | Ford | Kansas | 20057 | 1299 | 2 |
154826 | 154826 | 2020-05-18 | Ford | Illinois | 17053 | 18 | 1 |
155115 | 155115 | 2020-05-18 | Ford | Kansas | 20057 | 1403 | 2 |
157842 | 157842 | 2020-05-19 | Ford | Illinois | 17053 | 18 | 1 |
158132 | 158132 | 2020-05-19 | Ford | Kansas | 20057 | 1404 | 2 |
160868 | 160868 | 2020-05-20 | Ford | Illinois | 17053 | 18 | 1 |
161157 | 161157 | 2020-05-20 | Ford | Kansas | 20057 | 1440 | 2 |
163896 | 163896 | 2020-05-21 | Ford | Illinois | 17053 | 18 | 1 |
164186 | 164186 | 2020-05-21 | Ford | Kansas | 20057 | 1440 | 2 |
166929 | 166929 | 2020-05-22 | Ford | Illinois | 17053 | 19 | 1 |
167219 | 167219 | 2020-05-22 | Ford | Kansas | 20057 | 1558 | 2 |
169966 | 169966 | 2020-05-23 | Ford | Illinois | 17053 | 19 | 1 |
170257 | 170257 | 2020-05-23 | Ford | Kansas | 20057 | 1558 | 2 |
173007 | 173007 | 2020-05-24 | Ford | Illinois | 17053 | 20 | 1 |
173298 | 173298 | 2020-05-24 | Ford | Kansas | 20057 | 1558 | 2 |
176051 | 176051 | 2020-05-25 | Ford | Illinois | 17053 | 20 | 1 |
176342 | 176342 | 2020-05-25 | Ford | Kansas | 20057 | 1607 | 2 |
179095 | 179095 | 2020-05-26 | Ford | Illinois | 17053 | 20 | 1 |
179386 | 179386 | 2020-05-26 | Ford | Kansas | 20057 | 1607 | 2 |
182139 | 182139 | 2020-05-27 | Ford | Illinois | 17053 | 20 | 1 |
182431 | 182431 | 2020-05-27 | Ford | Kansas | 20057 | 1628 | 2 |
185193 | 185193 | 2020-05-28 | Ford | Illinois | 17053 | 20 | 1 |
185485 | 185485 | 2020-05-28 | Ford | Kansas | 20057 | 1628 | 2 |
188251 | 188251 | 2020-05-29 | Ford | Illinois | 17053 | 20 | 1 |
188543 | 188543 | 2020-05-29 | Ford | Kansas | 20057 | 1738 | 2 |
191316 | 191316 | 2020-05-30 | Ford | Illinois | 17053 | 20 | 1 |
191607 | 191607 | 2020-05-30 | Ford | Kansas | 20057 | 1738 | 2 |
194383 | 194383 | 2020-05-31 | Ford | Illinois | 17053 | 20 | 1 |
194675 | 194675 | 2020-05-31 | Ford | Kansas | 20057 | 1738 | 2 |
197453 | 197453 | 2020-06-01 | Ford | Illinois | 17053 | 20 | 1 |
197745 | 197745 | 2020-06-01 | Ford | Kansas | 20057 | 1790 | 2 |
200526 | 200526 | 2020-06-02 | Ford | Illinois | 17053 | 20 | 1 |
200817 | 200817 | 2020-06-02 | Ford | Kansas | 20057 | 1790 | 10 |
203602 | 203602 | 2020-06-03 | Ford | Illinois | 17053 | 20 | 1 |
203893 | 203893 | 2020-06-03 | Ford | Kansas | 20057 | 1804 | 10 |
206682 | 206682 | 2020-06-04 | Ford | Illinois | 17053 | 20 | 1 |
206974 | 206974 | 2020-06-04 | Ford | Kansas | 20057 | 1804 | 10 |
209763 | 209763 | 2020-06-05 | Ford | Illinois | 17053 | 21 | 1 |
210055 | 210055 | 2020-06-05 | Ford | Kansas | 20057 | 1823 | 10 |
212848 | 212848 | 2020-06-06 | Ford | Illinois | 17053 | 21 | 1 |
213140 | 213140 | 2020-06-06 | Ford | Kansas | 20057 | 1823 | 10 |
215935 | 215935 | 2020-06-07 | Ford | Illinois | 17053 | 21 | 1 |
216227 | 216227 | 2020-06-07 | Ford | Kansas | 20057 | 1823 | 10 |
219026 | 219026 | 2020-06-08 | Ford | Illinois | 17053 | 21 | 1 |
219319 | 219319 | 2020-06-08 | Ford | Kansas | 20057 | 1856 | 10 |
222121 | 222121 | 2020-06-09 | Ford | Illinois | 17053 | 21 | 1 |
222414 | 222414 | 2020-06-09 | Ford | Kansas | 20057 | 1856 | 10 |
225216 | 225216 | 2020-06-10 | Ford | Illinois | 17053 | 22 | 1 |
225509 | 225509 | 2020-06-10 | Ford | Kansas | 20057 | 1852 | 10 |
228318 | 228318 | 2020-06-11 | Ford | Illinois | 17053 | 22 | 1 |
228611 | 228611 | 2020-06-11 | Ford | Kansas | 20057 | 1852 | 10 |
231421 | 231421 | 2020-06-12 | Ford | Illinois | 17053 | 21 | 1 |
231714 | 231714 | 2020-06-12 | Ford | Kansas | 20057 | 1857 | 10 |
234527 | 234527 | 2020-06-13 | Ford | Illinois | 17053 | 22 | 1 |
234820 | 234820 | 2020-06-13 | Ford | Kansas | 20057 | 1857 | 10 |
237634 | 237634 | 2020-06-14 | Ford | Illinois | 17053 | 22 | 1 |
237927 | 237927 | 2020-06-14 | Ford | Kansas | 20057 | 1857 | 10 |
240742 | 240742 | 2020-06-15 | Ford | Illinois | 17053 | 22 | 1 |
241036 | 241036 | 2020-06-15 | Ford | Kansas | 20057 | 1882 | 10 |
243853 | 243853 | 2020-06-16 | Ford | Illinois | 17053 | 22 | 1 |
244147 | 244147 | 2020-06-16 | Ford | Kansas | 20057 | 1882 | 10 |
246966 | 246966 | 2020-06-17 | Ford | Illinois | 17053 | 22 | 1 |
247260 | 247260 | 2020-06-17 | Ford | Kansas | 20057 | 1897 | 10 |
250078 | 250078 | 2020-06-18 | Ford | Illinois | 17053 | 22 | 1 |
250372 | 250372 | 2020-06-18 | Ford | Kansas | 20057 | 1897 | 10 |
253193 | 253193 | 2020-06-19 | Ford | Illinois | 17053 | 22 | 1 |
253487 | 253487 | 2020-06-19 | Ford | Kansas | 20057 | 1916 | 10 |
256313 | 256313 | 2020-06-20 | Ford | Illinois | 17053 | 22 | 1 |
256607 | 256607 | 2020-06-20 | Ford | Kansas | 20057 | 1916 | 10 |
259439 | 259439 | 2020-06-21 | Ford | Illinois | 17053 | 22 | 1 |
259733 | 259733 | 2020-06-21 | Ford | Kansas | 20057 | 1916 | 10 |
262566 | 262566 | 2020-06-22 | Ford | Illinois | 17053 | 25 | 1 |
262860 | 262860 | 2020-06-22 | Ford | Kansas | 20057 | 1926 | 10 |
265694 | 265694 | 2020-06-23 | Ford | Illinois | 17053 | 26 | 1 |
265988 | 265988 | 2020-06-23 | Ford | Kansas | 20057 | 1926 | 10 |
268824 | 268824 | 2020-06-24 | Ford | Illinois | 17053 | 26 | 1 |
269118 | 269118 | 2020-06-24 | Ford | Kansas | 20057 | 1963 | 10 |
271961 | 271961 | 2020-06-25 | Ford | Illinois | 17053 | 26 | 1 |
272255 | 272255 | 2020-06-25 | Ford | Kansas | 20057 | 1963 | 10 |
275103 | 275103 | 2020-06-26 | Ford | Illinois | 17053 | 27 | 1 |
275398 | 275398 | 2020-06-26 | Ford | Kansas | 20057 | 1983 | 10 |
278251 | 278251 | 2020-06-27 | Ford | Illinois | 17053 | 30 | 1 |
278546 | 278546 | 2020-06-27 | Ford | Kansas | 20057 | 1983 | 10 |
281399 | 281399 | 2020-06-28 | Ford | Illinois | 17053 | 30 | 1 |
281694 | 281694 | 2020-06-28 | Ford | Kansas | 20057 | 1983 | 10 |
284544 | 284544 | 2020-06-29 | Ford | Illinois | 17053 | 31 | 1 |
284839 | 284839 | 2020-06-29 | Ford | Kansas | 20057 | 2006 | 10 |
287693 | 287693 | 2020-06-30 | Ford | Illinois | 17053 | 31 | 1 |
287988 | 287988 | 2020-06-30 | Ford | Kansas | 20057 | 2006 | 10 |
290843 | 290843 | 2020-07-01 | Ford | Illinois | 17053 | 33 | 1 |
291138 | 291138 | 2020-07-01 | Ford | Kansas | 20057 | 2008 | 10 |
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);