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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337432 | 2337432 | 2022-03-24 | Ford | Illinois | 17053 | 4389 | 73 |
2337729 | 2337729 | 2022-03-24 | Ford | Kansas | 20057 | 10611 | 108 |
2334178 | 2334178 | 2022-03-23 | Ford | Illinois | 17053 | 4389 | 73 |
2334475 | 2334475 | 2022-03-23 | Ford | Kansas | 20057 | 10611 | 108 |
2330924 | 2330924 | 2022-03-22 | Ford | Illinois | 17053 | 4389 | 73 |
2331221 | 2331221 | 2022-03-22 | Ford | Kansas | 20057 | 10608 | 108 |
2327672 | 2327672 | 2022-03-21 | Ford | Illinois | 17053 | 4388 | 73 |
2327969 | 2327969 | 2022-03-21 | Ford | Kansas | 20057 | 10608 | 108 |
2324419 | 2324419 | 2022-03-20 | Ford | Illinois | 17053 | 4388 | 73 |
2324716 | 2324716 | 2022-03-20 | Ford | Kansas | 20057 | 10608 | 108 |
2321165 | 2321165 | 2022-03-19 | Ford | Illinois | 17053 | 4388 | 73 |
2321462 | 2321462 | 2022-03-19 | Ford | Kansas | 20057 | 10608 | 108 |
2317911 | 2317911 | 2022-03-18 | Ford | Illinois | 17053 | 4388 | 73 |
2318208 | 2318208 | 2022-03-18 | Ford | Kansas | 20057 | 10608 | 108 |
2314658 | 2314658 | 2022-03-17 | Ford | Illinois | 17053 | 4387 | 73 |
2314955 | 2314955 | 2022-03-17 | Ford | Kansas | 20057 | 10606 | 108 |
2311405 | 2311405 | 2022-03-16 | Ford | Illinois | 17053 | 4387 | 73 |
2311702 | 2311702 | 2022-03-16 | Ford | Kansas | 20057 | 10606 | 108 |
2308152 | 2308152 | 2022-03-15 | Ford | Illinois | 17053 | 4386 | 73 |
2308449 | 2308449 | 2022-03-15 | Ford | Kansas | 20057 | 10602 | 108 |
2304901 | 2304901 | 2022-03-14 | Ford | Illinois | 17053 | 4386 | 73 |
2305198 | 2305198 | 2022-03-14 | Ford | Kansas | 20057 | 10602 | 108 |
2301649 | 2301649 | 2022-03-13 | Ford | Illinois | 17053 | 4386 | 72 |
2301946 | 2301946 | 2022-03-13 | Ford | Kansas | 20057 | 10595 | 108 |
2298397 | 2298397 | 2022-03-12 | Ford | Illinois | 17053 | 4386 | 72 |
2298694 | 2298694 | 2022-03-12 | Ford | Kansas | 20057 | 10595 | 108 |
2295145 | 2295145 | 2022-03-11 | Ford | Illinois | 17053 | 4386 | 72 |
2295442 | 2295442 | 2022-03-11 | Ford | Kansas | 20057 | 10595 | 108 |
2291893 | 2291893 | 2022-03-10 | Ford | Illinois | 17053 | 4385 | 72 |
2292190 | 2292190 | 2022-03-10 | Ford | Kansas | 20057 | 10591 | 108 |
2288641 | 2288641 | 2022-03-09 | Ford | Illinois | 17053 | 4385 | 72 |
2288938 | 2288938 | 2022-03-09 | Ford | Kansas | 20057 | 10591 | 108 |
2285390 | 2285390 | 2022-03-08 | Ford | Illinois | 17053 | 4385 | 72 |
2285687 | 2285687 | 2022-03-08 | Ford | Kansas | 20057 | 10586 | 108 |
2282138 | 2282138 | 2022-03-07 | Ford | Illinois | 17053 | 4385 | 72 |
2282435 | 2282435 | 2022-03-07 | Ford | Kansas | 20057 | 10586 | 108 |
2278885 | 2278885 | 2022-03-06 | Ford | Illinois | 17053 | 4385 | 72 |
2279182 | 2279182 | 2022-03-06 | Ford | Kansas | 20057 | 10582 | 108 |
2275632 | 2275632 | 2022-03-05 | Ford | Illinois | 17053 | 4385 | 72 |
2275929 | 2275929 | 2022-03-05 | Ford | Kansas | 20057 | 10582 | 108 |
2272379 | 2272379 | 2022-03-04 | Ford | Illinois | 17053 | 4385 | 72 |
2272676 | 2272676 | 2022-03-04 | Ford | Kansas | 20057 | 10582 | 108 |
2269127 | 2269127 | 2022-03-03 | Ford | Illinois | 17053 | 4384 | 72 |
2269424 | 2269424 | 2022-03-03 | Ford | Kansas | 20057 | 10578 | 108 |
2265874 | 2265874 | 2022-03-02 | Ford | Illinois | 17053 | 4382 | 72 |
2266171 | 2266171 | 2022-03-02 | Ford | Kansas | 20057 | 10578 | 108 |
2262623 | 2262623 | 2022-03-01 | Ford | Illinois | 17053 | 4380 | 72 |
2262920 | 2262920 | 2022-03-01 | Ford | Kansas | 20057 | 10573 | 108 |
2259372 | 2259372 | 2022-02-28 | Ford | Illinois | 17053 | 4378 | 72 |
2259669 | 2259669 | 2022-02-28 | Ford | Kansas | 20057 | 10573 | 108 |
2256121 | 2256121 | 2022-02-27 | Ford | Illinois | 17053 | 4375 | 72 |
2256418 | 2256418 | 2022-02-27 | Ford | Kansas | 20057 | 10570 | 107 |
2252870 | 2252870 | 2022-02-26 | Ford | Illinois | 17053 | 4375 | 72 |
2253167 | 2253167 | 2022-02-26 | Ford | Kansas | 20057 | 10570 | 107 |
2249619 | 2249619 | 2022-02-25 | Ford | Illinois | 17053 | 4375 | 72 |
2249916 | 2249916 | 2022-02-25 | Ford | Kansas | 20057 | 10570 | 107 |
2246368 | 2246368 | 2022-02-24 | Ford | Illinois | 17053 | 4373 | 72 |
2246665 | 2246665 | 2022-02-24 | Ford | Kansas | 20057 | 10563 | 107 |
2243117 | 2243117 | 2022-02-23 | Ford | Illinois | 17053 | 4373 | 72 |
2243414 | 2243414 | 2022-02-23 | Ford | Kansas | 20057 | 10563 | 107 |
2239866 | 2239866 | 2022-02-22 | Ford | Illinois | 17053 | 4373 | 72 |
2240163 | 2240163 | 2022-02-22 | Ford | Kansas | 20057 | 10557 | 107 |
2236615 | 2236615 | 2022-02-21 | Ford | Illinois | 17053 | 4367 | 71 |
2236912 | 2236912 | 2022-02-21 | Ford | Kansas | 20057 | 10557 | 107 |
2233364 | 2233364 | 2022-02-20 | Ford | Illinois | 17053 | 4367 | 71 |
2233661 | 2233661 | 2022-02-20 | Ford | Kansas | 20057 | 10552 | 107 |
2230113 | 2230113 | 2022-02-19 | Ford | Illinois | 17053 | 4367 | 71 |
2230410 | 2230410 | 2022-02-19 | Ford | Kansas | 20057 | 10552 | 107 |
2226862 | 2226862 | 2022-02-18 | Ford | Illinois | 17053 | 4367 | 71 |
2227159 | 2227159 | 2022-02-18 | Ford | Kansas | 20057 | 10552 | 107 |
2223611 | 2223611 | 2022-02-17 | Ford | Illinois | 17053 | 4362 | 71 |
2223908 | 2223908 | 2022-02-17 | Ford | Kansas | 20057 | 10540 | 107 |
2220360 | 2220360 | 2022-02-16 | Ford | Illinois | 17053 | 4362 | 71 |
2220657 | 2220657 | 2022-02-16 | Ford | Kansas | 20057 | 10540 | 107 |
2217109 | 2217109 | 2022-02-15 | Ford | Illinois | 17053 | 4353 | 71 |
2217406 | 2217406 | 2022-02-15 | Ford | Kansas | 20057 | 10526 | 107 |
2213858 | 2213858 | 2022-02-14 | Ford | Illinois | 17053 | 4345 | 71 |
2214155 | 2214155 | 2022-02-14 | Ford | Kansas | 20057 | 10526 | 107 |
2210606 | 2210606 | 2022-02-13 | Ford | Illinois | 17053 | 4329 | 71 |
2210903 | 2210903 | 2022-02-13 | Ford | Kansas | 20057 | 10499 | 106 |
2207353 | 2207353 | 2022-02-12 | Ford | Illinois | 17053 | 4329 | 71 |
2207650 | 2207650 | 2022-02-12 | Ford | Kansas | 20057 | 10499 | 106 |
2204100 | 2204100 | 2022-02-11 | Ford | Illinois | 17053 | 4329 | 71 |
2204397 | 2204397 | 2022-02-11 | Ford | Kansas | 20057 | 10499 | 106 |
2200847 | 2200847 | 2022-02-10 | Ford | Illinois | 17053 | 4329 | 71 |
2201144 | 2201144 | 2022-02-10 | Ford | Kansas | 20057 | 10499 | 106 |
2197593 | 2197593 | 2022-02-09 | Ford | Illinois | 17053 | 4320 | 71 |
2197890 | 2197890 | 2022-02-09 | Ford | Kansas | 20057 | 10499 | 106 |
2194339 | 2194339 | 2022-02-08 | Ford | Illinois | 17053 | 4310 | 71 |
2194636 | 2194636 | 2022-02-08 | Ford | Kansas | 20057 | 10470 | 105 |
2191085 | 2191085 | 2022-02-07 | Ford | Illinois | 17053 | 4297 | 70 |
2191382 | 2191382 | 2022-02-07 | Ford | Kansas | 20057 | 10470 | 105 |
2187832 | 2187832 | 2022-02-06 | Ford | Illinois | 17053 | 4284 | 70 |
2188129 | 2188129 | 2022-02-06 | Ford | Kansas | 20057 | 10447 | 105 |
2184579 | 2184579 | 2022-02-05 | Ford | Illinois | 17053 | 4284 | 70 |
2184876 | 2184876 | 2022-02-05 | Ford | Kansas | 20057 | 10447 | 105 |
2181327 | 2181327 | 2022-02-04 | Ford | Illinois | 17053 | 4284 | 70 |
2181624 | 2181624 | 2022-02-04 | Ford | Kansas | 20057 | 10447 | 105 |
2178076 | 2178076 | 2022-02-03 | Ford | Illinois | 17053 | 4252 | 70 |
2178373 | 2178373 | 2022-02-03 | Ford | Kansas | 20057 | 10432 | 103 |
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);