ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Richland" and fips = 17159 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500256 | 2500256 | 2022-05-13 | Richland | Illinois | 17159 | 5167 | 83 |
2496998 | 2496998 | 2022-05-12 | Richland | Illinois | 17159 | 5167 | 83 |
2493740 | 2493740 | 2022-05-11 | Richland | Illinois | 17159 | 5166 | 83 |
2490482 | 2490482 | 2022-05-10 | Richland | Illinois | 17159 | 5165 | 83 |
2487225 | 2487225 | 2022-05-09 | Richland | Illinois | 17159 | 5164 | 83 |
2483967 | 2483967 | 2022-05-08 | Richland | Illinois | 17159 | 5164 | 83 |
2480709 | 2480709 | 2022-05-07 | Richland | Illinois | 17159 | 5164 | 83 |
2477451 | 2477451 | 2022-05-06 | Richland | Illinois | 17159 | 5164 | 83 |
2474193 | 2474193 | 2022-05-05 | Richland | Illinois | 17159 | 5164 | 83 |
2470936 | 2470936 | 2022-05-04 | Richland | Illinois | 17159 | 5163 | 83 |
2467680 | 2467680 | 2022-05-03 | Richland | Illinois | 17159 | 5162 | 83 |
2464425 | 2464425 | 2022-05-02 | Richland | Illinois | 17159 | 5162 | 83 |
2461169 | 2461169 | 2022-05-01 | Richland | Illinois | 17159 | 5162 | 83 |
2457913 | 2457913 | 2022-04-30 | Richland | Illinois | 17159 | 5162 | 83 |
2454657 | 2454657 | 2022-04-29 | Richland | Illinois | 17159 | 5162 | 83 |
2451401 | 2451401 | 2022-04-28 | Richland | Illinois | 17159 | 5162 | 83 |
2448145 | 2448145 | 2022-04-27 | Richland | Illinois | 17159 | 5161 | 83 |
2444889 | 2444889 | 2022-04-26 | Richland | Illinois | 17159 | 5161 | 83 |
2441633 | 2441633 | 2022-04-25 | Richland | Illinois | 17159 | 5161 | 83 |
2438377 | 2438377 | 2022-04-24 | Richland | Illinois | 17159 | 5160 | 83 |
2435121 | 2435121 | 2022-04-23 | Richland | Illinois | 17159 | 5160 | 83 |
2431865 | 2431865 | 2022-04-22 | Richland | Illinois | 17159 | 5160 | 83 |
2428609 | 2428609 | 2022-04-21 | Richland | Illinois | 17159 | 5161 | 83 |
2425353 | 2425353 | 2022-04-20 | Richland | Illinois | 17159 | 5161 | 83 |
2422097 | 2422097 | 2022-04-19 | Richland | Illinois | 17159 | 5161 | 83 |
2418841 | 2418841 | 2022-04-18 | Richland | Illinois | 17159 | 5160 | 83 |
2415585 | 2415585 | 2022-04-17 | Richland | Illinois | 17159 | 5160 | 83 |
2412329 | 2412329 | 2022-04-16 | Richland | Illinois | 17159 | 5160 | 83 |
2409073 | 2409073 | 2022-04-15 | Richland | Illinois | 17159 | 5160 | 83 |
2405817 | 2405817 | 2022-04-14 | Richland | Illinois | 17159 | 5160 | 83 |
2402562 | 2402562 | 2022-04-13 | Richland | Illinois | 17159 | 5159 | 83 |
2399307 | 2399307 | 2022-04-12 | Richland | Illinois | 17159 | 5159 | 83 |
2396052 | 2396052 | 2022-04-11 | Richland | Illinois | 17159 | 5159 | 83 |
2392796 | 2392796 | 2022-04-10 | Richland | Illinois | 17159 | 5158 | 83 |
2389540 | 2389540 | 2022-04-09 | Richland | Illinois | 17159 | 5158 | 83 |
2386285 | 2386285 | 2022-04-08 | Richland | Illinois | 17159 | 5158 | 83 |
2383030 | 2383030 | 2022-04-07 | Richland | Illinois | 17159 | 5158 | 83 |
2379775 | 2379775 | 2022-04-06 | Richland | Illinois | 17159 | 5158 | 83 |
2376521 | 2376521 | 2022-04-05 | Richland | Illinois | 17159 | 5157 | 83 |
2373269 | 2373269 | 2022-04-04 | Richland | Illinois | 17159 | 5157 | 83 |
2370016 | 2370016 | 2022-04-03 | Richland | Illinois | 17159 | 5156 | 83 |
2366763 | 2366763 | 2022-04-02 | Richland | Illinois | 17159 | 5156 | 83 |
2363510 | 2363510 | 2022-04-01 | Richland | Illinois | 17159 | 5156 | 83 |
2360256 | 2360256 | 2022-03-31 | Richland | Illinois | 17159 | 5156 | 83 |
2357002 | 2357002 | 2022-03-30 | Richland | Illinois | 17159 | 5155 | 83 |
2353749 | 2353749 | 2022-03-29 | Richland | Illinois | 17159 | 5155 | 83 |
2350497 | 2350497 | 2022-03-28 | Richland | Illinois | 17159 | 5155 | 83 |
2347244 | 2347244 | 2022-03-27 | Richland | Illinois | 17159 | 5154 | 83 |
2343991 | 2343991 | 2022-03-26 | Richland | Illinois | 17159 | 5154 | 83 |
2340738 | 2340738 | 2022-03-25 | Richland | Illinois | 17159 | 5154 | 83 |
2337485 | 2337485 | 2022-03-24 | Richland | Illinois | 17159 | 5154 | 83 |
2334231 | 2334231 | 2022-03-23 | Richland | Illinois | 17159 | 5153 | 83 |
2330977 | 2330977 | 2022-03-22 | Richland | Illinois | 17159 | 5152 | 83 |
2327725 | 2327725 | 2022-03-21 | Richland | Illinois | 17159 | 5152 | 83 |
2324472 | 2324472 | 2022-03-20 | Richland | Illinois | 17159 | 5152 | 83 |
2321218 | 2321218 | 2022-03-19 | Richland | Illinois | 17159 | 5152 | 83 |
2317964 | 2317964 | 2022-03-18 | Richland | Illinois | 17159 | 5152 | 83 |
2314711 | 2314711 | 2022-03-17 | Richland | Illinois | 17159 | 5151 | 83 |
2311458 | 2311458 | 2022-03-16 | Richland | Illinois | 17159 | 5151 | 83 |
2308205 | 2308205 | 2022-03-15 | Richland | Illinois | 17159 | 5151 | 83 |
2304954 | 2304954 | 2022-03-14 | Richland | Illinois | 17159 | 5151 | 83 |
2301702 | 2301702 | 2022-03-13 | Richland | Illinois | 17159 | 5149 | 83 |
2298450 | 2298450 | 2022-03-12 | Richland | Illinois | 17159 | 5149 | 83 |
2295198 | 2295198 | 2022-03-11 | Richland | Illinois | 17159 | 5149 | 83 |
2291946 | 2291946 | 2022-03-10 | Richland | Illinois | 17159 | 5149 | 83 |
2288694 | 2288694 | 2022-03-09 | Richland | Illinois | 17159 | 5149 | 83 |
2285443 | 2285443 | 2022-03-08 | Richland | Illinois | 17159 | 5149 | 83 |
2282191 | 2282191 | 2022-03-07 | Richland | Illinois | 17159 | 5148 | 83 |
2278938 | 2278938 | 2022-03-06 | Richland | Illinois | 17159 | 5148 | 83 |
2275685 | 2275685 | 2022-03-05 | Richland | Illinois | 17159 | 5148 | 83 |
2272432 | 2272432 | 2022-03-04 | Richland | Illinois | 17159 | 5148 | 83 |
2269180 | 2269180 | 2022-03-03 | Richland | Illinois | 17159 | 5147 | 83 |
2265927 | 2265927 | 2022-03-02 | Richland | Illinois | 17159 | 5147 | 82 |
2262676 | 2262676 | 2022-03-01 | Richland | Illinois | 17159 | 5147 | 82 |
2259425 | 2259425 | 2022-02-28 | Richland | Illinois | 17159 | 5146 | 82 |
2256174 | 2256174 | 2022-02-27 | Richland | Illinois | 17159 | 5141 | 82 |
2252923 | 2252923 | 2022-02-26 | Richland | Illinois | 17159 | 5141 | 82 |
2249672 | 2249672 | 2022-02-25 | Richland | Illinois | 17159 | 5141 | 82 |
2246421 | 2246421 | 2022-02-24 | Richland | Illinois | 17159 | 5141 | 81 |
2243170 | 2243170 | 2022-02-23 | Richland | Illinois | 17159 | 5140 | 81 |
2239919 | 2239919 | 2022-02-22 | Richland | Illinois | 17159 | 5135 | 81 |
2236668 | 2236668 | 2022-02-21 | Richland | Illinois | 17159 | 5131 | 81 |
2233417 | 2233417 | 2022-02-20 | Richland | Illinois | 17159 | 5131 | 81 |
2230166 | 2230166 | 2022-02-19 | Richland | Illinois | 17159 | 5131 | 81 |
2226915 | 2226915 | 2022-02-18 | Richland | Illinois | 17159 | 5131 | 81 |
2223664 | 2223664 | 2022-02-17 | Richland | Illinois | 17159 | 5130 | 81 |
2220413 | 2220413 | 2022-02-16 | Richland | Illinois | 17159 | 5127 | 81 |
2217162 | 2217162 | 2022-02-15 | Richland | Illinois | 17159 | 5123 | 80 |
2213911 | 2213911 | 2022-02-14 | Richland | Illinois | 17159 | 5121 | 80 |
2210659 | 2210659 | 2022-02-13 | Richland | Illinois | 17159 | 5105 | 80 |
2207406 | 2207406 | 2022-02-12 | Richland | Illinois | 17159 | 5105 | 80 |
2204153 | 2204153 | 2022-02-11 | Richland | Illinois | 17159 | 5105 | 80 |
2200900 | 2200900 | 2022-02-10 | Richland | Illinois | 17159 | 5105 | 80 |
2197646 | 2197646 | 2022-02-09 | Richland | Illinois | 17159 | 5091 | 80 |
2194392 | 2194392 | 2022-02-08 | Richland | Illinois | 17159 | 5077 | 80 |
2191138 | 2191138 | 2022-02-07 | Richland | Illinois | 17159 | 5056 | 80 |
2187885 | 2187885 | 2022-02-06 | Richland | Illinois | 17159 | 5031 | 80 |
2184632 | 2184632 | 2022-02-05 | Richland | Illinois | 17159 | 5031 | 80 |
2181380 | 2181380 | 2022-02-04 | Richland | Illinois | 17159 | 5031 | 80 |
2178129 | 2178129 | 2022-02-03 | Richland | Illinois | 17159 | 4999 | 79 |
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);