ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Carroll" and fips = 17015 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 |
---|---|---|---|---|---|---|---|
2500184 | 2500184 | 2022-05-13 | Carroll | Illinois | 17015 | 4301 | 49 |
2496926 | 2496926 | 2022-05-12 | Carroll | Illinois | 17015 | 4300 | 49 |
2493668 | 2493668 | 2022-05-11 | Carroll | Illinois | 17015 | 4300 | 49 |
2490410 | 2490410 | 2022-05-10 | Carroll | Illinois | 17015 | 4295 | 49 |
2487153 | 2487153 | 2022-05-09 | Carroll | Illinois | 17015 | 4292 | 49 |
2483895 | 2483895 | 2022-05-08 | Carroll | Illinois | 17015 | 4287 | 49 |
2480637 | 2480637 | 2022-05-07 | Carroll | Illinois | 17015 | 4287 | 49 |
2477379 | 2477379 | 2022-05-06 | Carroll | Illinois | 17015 | 4287 | 49 |
2474121 | 2474121 | 2022-05-05 | Carroll | Illinois | 17015 | 4283 | 49 |
2470864 | 2470864 | 2022-05-04 | Carroll | Illinois | 17015 | 4282 | 49 |
2467608 | 2467608 | 2022-05-03 | Carroll | Illinois | 17015 | 4280 | 49 |
2464353 | 2464353 | 2022-05-02 | Carroll | Illinois | 17015 | 4275 | 49 |
2461097 | 2461097 | 2022-05-01 | Carroll | Illinois | 17015 | 4271 | 49 |
2457841 | 2457841 | 2022-04-30 | Carroll | Illinois | 17015 | 4271 | 49 |
2454585 | 2454585 | 2022-04-29 | Carroll | Illinois | 17015 | 4271 | 49 |
2451329 | 2451329 | 2022-04-28 | Carroll | Illinois | 17015 | 4270 | 49 |
2448073 | 2448073 | 2022-04-27 | Carroll | Illinois | 17015 | 4268 | 49 |
2444817 | 2444817 | 2022-04-26 | Carroll | Illinois | 17015 | 4263 | 49 |
2441561 | 2441561 | 2022-04-25 | Carroll | Illinois | 17015 | 4255 | 49 |
2438305 | 2438305 | 2022-04-24 | Carroll | Illinois | 17015 | 4252 | 49 |
2435049 | 2435049 | 2022-04-23 | Carroll | Illinois | 17015 | 4252 | 49 |
2431793 | 2431793 | 2022-04-22 | Carroll | Illinois | 17015 | 4252 | 49 |
2428537 | 2428537 | 2022-04-21 | Carroll | Illinois | 17015 | 4250 | 49 |
2425281 | 2425281 | 2022-04-20 | Carroll | Illinois | 17015 | 4250 | 49 |
2422025 | 2422025 | 2022-04-19 | Carroll | Illinois | 17015 | 4249 | 49 |
2418769 | 2418769 | 2022-04-18 | Carroll | Illinois | 17015 | 4249 | 49 |
2415513 | 2415513 | 2022-04-17 | Carroll | Illinois | 17015 | 4247 | 49 |
2412257 | 2412257 | 2022-04-16 | Carroll | Illinois | 17015 | 4247 | 49 |
2409001 | 2409001 | 2022-04-15 | Carroll | Illinois | 17015 | 4247 | 49 |
2405745 | 2405745 | 2022-04-14 | Carroll | Illinois | 17015 | 4246 | 49 |
2402490 | 2402490 | 2022-04-13 | Carroll | Illinois | 17015 | 4246 | 49 |
2399235 | 2399235 | 2022-04-12 | Carroll | Illinois | 17015 | 4246 | 49 |
2395980 | 2395980 | 2022-04-11 | Carroll | Illinois | 17015 | 4245 | 49 |
2392724 | 2392724 | 2022-04-10 | Carroll | Illinois | 17015 | 4244 | 49 |
2389468 | 2389468 | 2022-04-09 | Carroll | Illinois | 17015 | 4244 | 49 |
2386213 | 2386213 | 2022-04-08 | Carroll | Illinois | 17015 | 4244 | 49 |
2382958 | 2382958 | 2022-04-07 | Carroll | Illinois | 17015 | 4244 | 49 |
2379703 | 2379703 | 2022-04-06 | Carroll | Illinois | 17015 | 4244 | 49 |
2376449 | 2376449 | 2022-04-05 | Carroll | Illinois | 17015 | 4244 | 49 |
2373197 | 2373197 | 2022-04-04 | Carroll | Illinois | 17015 | 4243 | 49 |
2369944 | 2369944 | 2022-04-03 | Carroll | Illinois | 17015 | 4243 | 49 |
2366691 | 2366691 | 2022-04-02 | Carroll | Illinois | 17015 | 4243 | 49 |
2363438 | 2363438 | 2022-04-01 | Carroll | Illinois | 17015 | 4243 | 49 |
2360184 | 2360184 | 2022-03-31 | Carroll | Illinois | 17015 | 4243 | 49 |
2356930 | 2356930 | 2022-03-30 | Carroll | Illinois | 17015 | 4243 | 49 |
2353677 | 2353677 | 2022-03-29 | Carroll | Illinois | 17015 | 4241 | 49 |
2350425 | 2350425 | 2022-03-28 | Carroll | Illinois | 17015 | 4238 | 49 |
2347172 | 2347172 | 2022-03-27 | Carroll | Illinois | 17015 | 4237 | 49 |
2343919 | 2343919 | 2022-03-26 | Carroll | Illinois | 17015 | 4237 | 49 |
2340666 | 2340666 | 2022-03-25 | Carroll | Illinois | 17015 | 4237 | 49 |
2337413 | 2337413 | 2022-03-24 | Carroll | Illinois | 17015 | 4237 | 49 |
2334159 | 2334159 | 2022-03-23 | Carroll | Illinois | 17015 | 4236 | 49 |
2330905 | 2330905 | 2022-03-22 | Carroll | Illinois | 17015 | 4236 | 49 |
2327653 | 2327653 | 2022-03-21 | Carroll | Illinois | 17015 | 4236 | 49 |
2324400 | 2324400 | 2022-03-20 | Carroll | Illinois | 17015 | 4233 | 49 |
2321146 | 2321146 | 2022-03-19 | Carroll | Illinois | 17015 | 4233 | 49 |
2317892 | 2317892 | 2022-03-18 | Carroll | Illinois | 17015 | 4233 | 49 |
2314639 | 2314639 | 2022-03-17 | Carroll | Illinois | 17015 | 4233 | 48 |
2311386 | 2311386 | 2022-03-16 | Carroll | Illinois | 17015 | 4230 | 48 |
2308133 | 2308133 | 2022-03-15 | Carroll | Illinois | 17015 | 4229 | 48 |
2304882 | 2304882 | 2022-03-14 | Carroll | Illinois | 17015 | 4228 | 48 |
2301630 | 2301630 | 2022-03-13 | Carroll | Illinois | 17015 | 4227 | 48 |
2298378 | 2298378 | 2022-03-12 | Carroll | Illinois | 17015 | 4227 | 48 |
2295126 | 2295126 | 2022-03-11 | Carroll | Illinois | 17015 | 4227 | 48 |
2291874 | 2291874 | 2022-03-10 | Carroll | Illinois | 17015 | 4225 | 48 |
2288622 | 2288622 | 2022-03-09 | Carroll | Illinois | 17015 | 4225 | 48 |
2285371 | 2285371 | 2022-03-08 | Carroll | Illinois | 17015 | 4221 | 48 |
2282119 | 2282119 | 2022-03-07 | Carroll | Illinois | 17015 | 4220 | 48 |
2278866 | 2278866 | 2022-03-06 | Carroll | Illinois | 17015 | 4206 | 48 |
2275613 | 2275613 | 2022-03-05 | Carroll | Illinois | 17015 | 4206 | 48 |
2272360 | 2272360 | 2022-03-04 | Carroll | Illinois | 17015 | 4206 | 48 |
2269108 | 2269108 | 2022-03-03 | Carroll | Illinois | 17015 | 4204 | 48 |
2265855 | 2265855 | 2022-03-02 | Carroll | Illinois | 17015 | 4199 | 48 |
2262604 | 2262604 | 2022-03-01 | Carroll | Illinois | 17015 | 4200 | 48 |
2259353 | 2259353 | 2022-02-28 | Carroll | Illinois | 17015 | 4197 | 47 |
2256102 | 2256102 | 2022-02-27 | Carroll | Illinois | 17015 | 4186 | 47 |
2252851 | 2252851 | 2022-02-26 | Carroll | Illinois | 17015 | 4186 | 47 |
2249600 | 2249600 | 2022-02-25 | Carroll | Illinois | 17015 | 4186 | 47 |
2246349 | 2246349 | 2022-02-24 | Carroll | Illinois | 17015 | 4180 | 47 |
2243098 | 2243098 | 2022-02-23 | Carroll | Illinois | 17015 | 4179 | 47 |
2239847 | 2239847 | 2022-02-22 | Carroll | Illinois | 17015 | 4174 | 47 |
2236596 | 2236596 | 2022-02-21 | Carroll | Illinois | 17015 | 4166 | 47 |
2233345 | 2233345 | 2022-02-20 | Carroll | Illinois | 17015 | 4166 | 47 |
2230094 | 2230094 | 2022-02-19 | Carroll | Illinois | 17015 | 4166 | 47 |
2226843 | 2226843 | 2022-02-18 | Carroll | Illinois | 17015 | 4166 | 47 |
2223592 | 2223592 | 2022-02-17 | Carroll | Illinois | 17015 | 4142 | 47 |
2220341 | 2220341 | 2022-02-16 | Carroll | Illinois | 17015 | 4106 | 47 |
2217090 | 2217090 | 2022-02-15 | Carroll | Illinois | 17015 | 4096 | 47 |
2213839 | 2213839 | 2022-02-14 | Carroll | Illinois | 17015 | 4088 | 47 |
2210587 | 2210587 | 2022-02-13 | Carroll | Illinois | 17015 | 4076 | 47 |
2207334 | 2207334 | 2022-02-12 | Carroll | Illinois | 17015 | 4076 | 47 |
2204081 | 2204081 | 2022-02-11 | Carroll | Illinois | 17015 | 4076 | 47 |
2200828 | 2200828 | 2022-02-10 | Carroll | Illinois | 17015 | 4076 | 47 |
2197574 | 2197574 | 2022-02-09 | Carroll | Illinois | 17015 | 4074 | 47 |
2194320 | 2194320 | 2022-02-08 | Carroll | Illinois | 17015 | 4066 | 47 |
2191066 | 2191066 | 2022-02-07 | Carroll | Illinois | 17015 | 4062 | 47 |
2187813 | 2187813 | 2022-02-06 | Carroll | Illinois | 17015 | 4018 | 46 |
2184560 | 2184560 | 2022-02-05 | Carroll | Illinois | 17015 | 4018 | 46 |
2181308 | 2181308 | 2022-02-04 | Carroll | Illinois | 17015 | 4018 | 46 |
2178057 | 2178057 | 2022-02-03 | Carroll | Illinois | 17015 | 3893 | 46 |
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);