ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 17059 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500206 | 2500206 | 2022-05-13 | Gallatin | Illinois | 17059 | 1415 | 18 |
2496948 | 2496948 | 2022-05-12 | Gallatin | Illinois | 17059 | 1415 | 18 |
2493690 | 2493690 | 2022-05-11 | Gallatin | Illinois | 17059 | 1414 | 18 |
2490432 | 2490432 | 2022-05-10 | Gallatin | Illinois | 17059 | 1412 | 18 |
2487175 | 2487175 | 2022-05-09 | Gallatin | Illinois | 17059 | 1411 | 18 |
2483917 | 2483917 | 2022-05-08 | Gallatin | Illinois | 17059 | 1410 | 18 |
2480659 | 2480659 | 2022-05-07 | Gallatin | Illinois | 17059 | 1410 | 18 |
2477401 | 2477401 | 2022-05-06 | Gallatin | Illinois | 17059 | 1410 | 18 |
2474143 | 2474143 | 2022-05-05 | Gallatin | Illinois | 17059 | 1410 | 18 |
2470886 | 2470886 | 2022-05-04 | Gallatin | Illinois | 17059 | 1410 | 18 |
2467630 | 2467630 | 2022-05-03 | Gallatin | Illinois | 17059 | 1408 | 18 |
2464375 | 2464375 | 2022-05-02 | Gallatin | Illinois | 17059 | 1408 | 18 |
2461119 | 2461119 | 2022-05-01 | Gallatin | Illinois | 17059 | 1408 | 18 |
2457863 | 2457863 | 2022-04-30 | Gallatin | Illinois | 17059 | 1408 | 18 |
2454607 | 2454607 | 2022-04-29 | Gallatin | Illinois | 17059 | 1408 | 18 |
2451351 | 2451351 | 2022-04-28 | Gallatin | Illinois | 17059 | 1407 | 18 |
2448095 | 2448095 | 2022-04-27 | Gallatin | Illinois | 17059 | 1407 | 18 |
2444839 | 2444839 | 2022-04-26 | Gallatin | Illinois | 17059 | 1407 | 18 |
2441583 | 2441583 | 2022-04-25 | Gallatin | Illinois | 17059 | 1407 | 18 |
2438327 | 2438327 | 2022-04-24 | Gallatin | Illinois | 17059 | 1407 | 18 |
2435071 | 2435071 | 2022-04-23 | Gallatin | Illinois | 17059 | 1407 | 18 |
2431815 | 2431815 | 2022-04-22 | Gallatin | Illinois | 17059 | 1407 | 18 |
2428559 | 2428559 | 2022-04-21 | Gallatin | Illinois | 17059 | 1407 | 18 |
2425303 | 2425303 | 2022-04-20 | Gallatin | Illinois | 17059 | 1407 | 18 |
2422047 | 2422047 | 2022-04-19 | Gallatin | Illinois | 17059 | 1407 | 18 |
2418791 | 2418791 | 2022-04-18 | Gallatin | Illinois | 17059 | 1408 | 18 |
2415535 | 2415535 | 2022-04-17 | Gallatin | Illinois | 17059 | 1408 | 18 |
2412279 | 2412279 | 2022-04-16 | Gallatin | Illinois | 17059 | 1408 | 18 |
2409023 | 2409023 | 2022-04-15 | Gallatin | Illinois | 17059 | 1408 | 18 |
2405767 | 2405767 | 2022-04-14 | Gallatin | Illinois | 17059 | 1407 | 18 |
2402512 | 2402512 | 2022-04-13 | Gallatin | Illinois | 17059 | 1407 | 18 |
2399257 | 2399257 | 2022-04-12 | Gallatin | Illinois | 17059 | 1406 | 18 |
2396002 | 2396002 | 2022-04-11 | Gallatin | Illinois | 17059 | 1406 | 18 |
2392746 | 2392746 | 2022-04-10 | Gallatin | Illinois | 17059 | 1407 | 18 |
2389490 | 2389490 | 2022-04-09 | Gallatin | Illinois | 17059 | 1407 | 18 |
2386235 | 2386235 | 2022-04-08 | Gallatin | Illinois | 17059 | 1407 | 18 |
2382980 | 2382980 | 2022-04-07 | Gallatin | Illinois | 17059 | 1407 | 18 |
2379725 | 2379725 | 2022-04-06 | Gallatin | Illinois | 17059 | 1407 | 18 |
2376471 | 2376471 | 2022-04-05 | Gallatin | Illinois | 17059 | 1406 | 18 |
2373219 | 2373219 | 2022-04-04 | Gallatin | Illinois | 17059 | 1406 | 18 |
2369966 | 2369966 | 2022-04-03 | Gallatin | Illinois | 17059 | 1406 | 18 |
2366713 | 2366713 | 2022-04-02 | Gallatin | Illinois | 17059 | 1406 | 18 |
2363460 | 2363460 | 2022-04-01 | Gallatin | Illinois | 17059 | 1406 | 18 |
2360206 | 2360206 | 2022-03-31 | Gallatin | Illinois | 17059 | 1406 | 18 |
2356952 | 2356952 | 2022-03-30 | Gallatin | Illinois | 17059 | 1406 | 17 |
2353699 | 2353699 | 2022-03-29 | Gallatin | Illinois | 17059 | 1406 | 17 |
2350447 | 2350447 | 2022-03-28 | Gallatin | Illinois | 17059 | 1403 | 17 |
2347194 | 2347194 | 2022-03-27 | Gallatin | Illinois | 17059 | 1403 | 17 |
2343941 | 2343941 | 2022-03-26 | Gallatin | Illinois | 17059 | 1403 | 17 |
2340688 | 2340688 | 2022-03-25 | Gallatin | Illinois | 17059 | 1403 | 17 |
2337435 | 2337435 | 2022-03-24 | Gallatin | Illinois | 17059 | 1403 | 17 |
2334181 | 2334181 | 2022-03-23 | Gallatin | Illinois | 17059 | 1402 | 17 |
2330927 | 2330927 | 2022-03-22 | Gallatin | Illinois | 17059 | 1402 | 17 |
2327675 | 2327675 | 2022-03-21 | Gallatin | Illinois | 17059 | 1402 | 17 |
2324422 | 2324422 | 2022-03-20 | Gallatin | Illinois | 17059 | 1402 | 17 |
2321168 | 2321168 | 2022-03-19 | Gallatin | Illinois | 17059 | 1402 | 17 |
2317914 | 2317914 | 2022-03-18 | Gallatin | Illinois | 17059 | 1402 | 17 |
2314661 | 2314661 | 2022-03-17 | Gallatin | Illinois | 17059 | 1401 | 17 |
2311408 | 2311408 | 2022-03-16 | Gallatin | Illinois | 17059 | 1401 | 17 |
2308155 | 2308155 | 2022-03-15 | Gallatin | Illinois | 17059 | 1399 | 17 |
2304904 | 2304904 | 2022-03-14 | Gallatin | Illinois | 17059 | 1399 | 17 |
2301652 | 2301652 | 2022-03-13 | Gallatin | Illinois | 17059 | 1396 | 17 |
2298400 | 2298400 | 2022-03-12 | Gallatin | Illinois | 17059 | 1396 | 17 |
2295148 | 2295148 | 2022-03-11 | Gallatin | Illinois | 17059 | 1396 | 17 |
2291896 | 2291896 | 2022-03-10 | Gallatin | Illinois | 17059 | 1394 | 17 |
2288644 | 2288644 | 2022-03-09 | Gallatin | Illinois | 17059 | 1394 | 17 |
2285393 | 2285393 | 2022-03-08 | Gallatin | Illinois | 17059 | 1394 | 17 |
2282141 | 2282141 | 2022-03-07 | Gallatin | Illinois | 17059 | 1393 | 17 |
2278888 | 2278888 | 2022-03-06 | Gallatin | Illinois | 17059 | 1393 | 17 |
2275635 | 2275635 | 2022-03-05 | Gallatin | Illinois | 17059 | 1393 | 17 |
2272382 | 2272382 | 2022-03-04 | Gallatin | Illinois | 17059 | 1393 | 17 |
2269130 | 2269130 | 2022-03-03 | Gallatin | Illinois | 17059 | 1392 | 17 |
2265877 | 2265877 | 2022-03-02 | Gallatin | Illinois | 17059 | 1393 | 17 |
2262626 | 2262626 | 2022-03-01 | Gallatin | Illinois | 17059 | 1390 | 17 |
2259375 | 2259375 | 2022-02-28 | Gallatin | Illinois | 17059 | 1389 | 17 |
2256124 | 2256124 | 2022-02-27 | Gallatin | Illinois | 17059 | 1383 | 17 |
2252873 | 2252873 | 2022-02-26 | Gallatin | Illinois | 17059 | 1383 | 17 |
2249622 | 2249622 | 2022-02-25 | Gallatin | Illinois | 17059 | 1383 | 17 |
2246371 | 2246371 | 2022-02-24 | Gallatin | Illinois | 17059 | 1383 | 17 |
2243120 | 2243120 | 2022-02-23 | Gallatin | Illinois | 17059 | 1382 | 17 |
2239869 | 2239869 | 2022-02-22 | Gallatin | Illinois | 17059 | 1381 | 16 |
2236618 | 2236618 | 2022-02-21 | Gallatin | Illinois | 17059 | 1377 | 16 |
2233367 | 2233367 | 2022-02-20 | Gallatin | Illinois | 17059 | 1377 | 16 |
2230116 | 2230116 | 2022-02-19 | Gallatin | Illinois | 17059 | 1377 | 16 |
2226865 | 2226865 | 2022-02-18 | Gallatin | Illinois | 17059 | 1377 | 16 |
2223614 | 2223614 | 2022-02-17 | Gallatin | Illinois | 17059 | 1368 | 15 |
2220363 | 2220363 | 2022-02-16 | Gallatin | Illinois | 17059 | 1368 | 15 |
2217112 | 2217112 | 2022-02-15 | Gallatin | Illinois | 17059 | 1367 | 14 |
2213861 | 2213861 | 2022-02-14 | Gallatin | Illinois | 17059 | 1365 | 14 |
2210609 | 2210609 | 2022-02-13 | Gallatin | Illinois | 17059 | 1341 | 14 |
2207356 | 2207356 | 2022-02-12 | Gallatin | Illinois | 17059 | 1341 | 14 |
2204103 | 2204103 | 2022-02-11 | Gallatin | Illinois | 17059 | 1341 | 14 |
2200850 | 2200850 | 2022-02-10 | Gallatin | Illinois | 17059 | 1341 | 14 |
2197596 | 2197596 | 2022-02-09 | Gallatin | Illinois | 17059 | 1335 | 13 |
2194342 | 2194342 | 2022-02-08 | Gallatin | Illinois | 17059 | 1333 | 13 |
2191088 | 2191088 | 2022-02-07 | Gallatin | Illinois | 17059 | 1325 | 13 |
2187835 | 2187835 | 2022-02-06 | Gallatin | Illinois | 17059 | 1302 | 13 |
2184582 | 2184582 | 2022-02-05 | Gallatin | Illinois | 17059 | 1302 | 13 |
2181330 | 2181330 | 2022-02-04 | Gallatin | Illinois | 17059 | 1302 | 13 |
2178079 | 2178079 | 2022-02-03 | Gallatin | Illinois | 17059 | 1283 | 13 |
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);