ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193 rows where deaths = 140 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500182 | 2500182 | 2022-05-13 | Bureau | Illinois | 17011 | 8461 | 140 |
2500208 | 2500208 | 2022-05-13 | Grundy | Illinois | 17063 | 13009 | 140 |
2496924 | 2496924 | 2022-05-12 | Bureau | Illinois | 17011 | 8454 | 140 |
2496950 | 2496950 | 2022-05-12 | Grundy | Illinois | 17063 | 12988 | 140 |
2493666 | 2493666 | 2022-05-11 | Bureau | Illinois | 17011 | 8445 | 140 |
2493692 | 2493692 | 2022-05-11 | Grundy | Illinois | 17063 | 12979 | 140 |
2490408 | 2490408 | 2022-05-10 | Bureau | Illinois | 17011 | 8436 | 140 |
2490434 | 2490434 | 2022-05-10 | Grundy | Illinois | 17063 | 12963 | 140 |
2487151 | 2487151 | 2022-05-09 | Bureau | Illinois | 17011 | 8426 | 140 |
2487177 | 2487177 | 2022-05-09 | Grundy | Illinois | 17063 | 12945 | 140 |
2483893 | 2483893 | 2022-05-08 | Bureau | Illinois | 17011 | 8422 | 140 |
2483919 | 2483919 | 2022-05-08 | Grundy | Illinois | 17063 | 12903 | 140 |
2480635 | 2480635 | 2022-05-07 | Bureau | Illinois | 17011 | 8422 | 140 |
2480661 | 2480661 | 2022-05-07 | Grundy | Illinois | 17063 | 12903 | 140 |
2477377 | 2477377 | 2022-05-06 | Bureau | Illinois | 17011 | 8422 | 140 |
2477403 | 2477403 | 2022-05-06 | Grundy | Illinois | 17063 | 12903 | 140 |
2474119 | 2474119 | 2022-05-05 | Bureau | Illinois | 17011 | 8414 | 140 |
2474145 | 2474145 | 2022-05-05 | Grundy | Illinois | 17063 | 12884 | 140 |
2470862 | 2470862 | 2022-05-04 | Bureau | Illinois | 17011 | 8412 | 140 |
2470888 | 2470888 | 2022-05-04 | Grundy | Illinois | 17063 | 12869 | 140 |
2467606 | 2467606 | 2022-05-03 | Bureau | Illinois | 17011 | 8409 | 140 |
2467632 | 2467632 | 2022-05-03 | Grundy | Illinois | 17063 | 12861 | 140 |
2464351 | 2464351 | 2022-05-02 | Bureau | Illinois | 17011 | 8405 | 140 |
2464377 | 2464377 | 2022-05-02 | Grundy | Illinois | 17063 | 12843 | 140 |
2461095 | 2461095 | 2022-05-01 | Bureau | Illinois | 17011 | 8396 | 140 |
2461121 | 2461121 | 2022-05-01 | Grundy | Illinois | 17063 | 12820 | 140 |
2457839 | 2457839 | 2022-04-30 | Bureau | Illinois | 17011 | 8396 | 140 |
2457865 | 2457865 | 2022-04-30 | Grundy | Illinois | 17063 | 12820 | 140 |
2454583 | 2454583 | 2022-04-29 | Bureau | Illinois | 17011 | 8396 | 140 |
2454609 | 2454609 | 2022-04-29 | Grundy | Illinois | 17063 | 12820 | 140 |
2451327 | 2451327 | 2022-04-28 | Bureau | Illinois | 17011 | 8391 | 140 |
2451353 | 2451353 | 2022-04-28 | Grundy | Illinois | 17063 | 12804 | 140 |
2448071 | 2448071 | 2022-04-27 | Bureau | Illinois | 17011 | 8387 | 140 |
2448097 | 2448097 | 2022-04-27 | Grundy | Illinois | 17063 | 12788 | 140 |
2444815 | 2444815 | 2022-04-26 | Bureau | Illinois | 17011 | 8382 | 140 |
2444841 | 2444841 | 2022-04-26 | Grundy | Illinois | 17063 | 12778 | 140 |
2441559 | 2441559 | 2022-04-25 | Bureau | Illinois | 17011 | 8379 | 140 |
2441585 | 2441585 | 2022-04-25 | Grundy | Illinois | 17063 | 12760 | 140 |
2438303 | 2438303 | 2022-04-24 | Bureau | Illinois | 17011 | 8377 | 140 |
2438329 | 2438329 | 2022-04-24 | Grundy | Illinois | 17063 | 12734 | 140 |
2435047 | 2435047 | 2022-04-23 | Bureau | Illinois | 17011 | 8377 | 140 |
2435073 | 2435073 | 2022-04-23 | Grundy | Illinois | 17063 | 12734 | 140 |
2431791 | 2431791 | 2022-04-22 | Bureau | Illinois | 17011 | 8377 | 140 |
2431817 | 2431817 | 2022-04-22 | Grundy | Illinois | 17063 | 12734 | 140 |
2428535 | 2428535 | 2022-04-21 | Bureau | Illinois | 17011 | 8373 | 140 |
2428561 | 2428561 | 2022-04-21 | Grundy | Illinois | 17063 | 12723 | 140 |
2425279 | 2425279 | 2022-04-20 | Bureau | Illinois | 17011 | 8368 | 140 |
2425305 | 2425305 | 2022-04-20 | Grundy | Illinois | 17063 | 12711 | 140 |
2422023 | 2422023 | 2022-04-19 | Bureau | Illinois | 17011 | 8363 | 140 |
2422049 | 2422049 | 2022-04-19 | Grundy | Illinois | 17063 | 12698 | 140 |
2418767 | 2418767 | 2022-04-18 | Bureau | Illinois | 17011 | 8360 | 140 |
2418793 | 2418793 | 2022-04-18 | Grundy | Illinois | 17063 | 12689 | 140 |
2415511 | 2415511 | 2022-04-17 | Bureau | Illinois | 17011 | 8354 | 140 |
2415537 | 2415537 | 2022-04-17 | Grundy | Illinois | 17063 | 12680 | 140 |
2412255 | 2412255 | 2022-04-16 | Bureau | Illinois | 17011 | 8354 | 140 |
2412281 | 2412281 | 2022-04-16 | Grundy | Illinois | 17063 | 12680 | 140 |
2408999 | 2408999 | 2022-04-15 | Bureau | Illinois | 17011 | 8354 | 140 |
2409025 | 2409025 | 2022-04-15 | Grundy | Illinois | 17063 | 12680 | 140 |
2405743 | 2405743 | 2022-04-14 | Bureau | Illinois | 17011 | 8351 | 140 |
2405769 | 2405769 | 2022-04-14 | Grundy | Illinois | 17063 | 12677 | 140 |
2402488 | 2402488 | 2022-04-13 | Bureau | Illinois | 17011 | 8351 | 140 |
2402514 | 2402514 | 2022-04-13 | Grundy | Illinois | 17063 | 12668 | 140 |
2399233 | 2399233 | 2022-04-12 | Bureau | Illinois | 17011 | 8346 | 140 |
2399259 | 2399259 | 2022-04-12 | Grundy | Illinois | 17063 | 12661 | 140 |
2395978 | 2395978 | 2022-04-11 | Bureau | Illinois | 17011 | 8344 | 140 |
2396004 | 2396004 | 2022-04-11 | Grundy | Illinois | 17063 | 12656 | 140 |
2392722 | 2392722 | 2022-04-10 | Bureau | Illinois | 17011 | 8341 | 140 |
2392748 | 2392748 | 2022-04-10 | Grundy | Illinois | 17063 | 12640 | 140 |
2389466 | 2389466 | 2022-04-09 | Bureau | Illinois | 17011 | 8341 | 140 |
2389492 | 2389492 | 2022-04-09 | Grundy | Illinois | 17063 | 12640 | 140 |
2386211 | 2386211 | 2022-04-08 | Bureau | Illinois | 17011 | 8341 | 140 |
2386237 | 2386237 | 2022-04-08 | Grundy | Illinois | 17063 | 12640 | 140 |
2382956 | 2382956 | 2022-04-07 | Bureau | Illinois | 17011 | 8339 | 140 |
2382982 | 2382982 | 2022-04-07 | Grundy | Illinois | 17063 | 12636 | 140 |
2379701 | 2379701 | 2022-04-06 | Bureau | Illinois | 17011 | 8338 | 140 |
2379727 | 2379727 | 2022-04-06 | Grundy | Illinois | 17063 | 12633 | 140 |
2376447 | 2376447 | 2022-04-05 | Bureau | Illinois | 17011 | 8337 | 140 |
2376473 | 2376473 | 2022-04-05 | Grundy | Illinois | 17063 | 12624 | 140 |
2373195 | 2373195 | 2022-04-04 | Bureau | Illinois | 17011 | 8336 | 140 |
2373221 | 2373221 | 2022-04-04 | Grundy | Illinois | 17063 | 12619 | 140 |
2369942 | 2369942 | 2022-04-03 | Bureau | Illinois | 17011 | 8335 | 140 |
2369968 | 2369968 | 2022-04-03 | Grundy | Illinois | 17063 | 12616 | 140 |
2366689 | 2366689 | 2022-04-02 | Bureau | Illinois | 17011 | 8335 | 140 |
2366715 | 2366715 | 2022-04-02 | Grundy | Illinois | 17063 | 12616 | 140 |
2363436 | 2363436 | 2022-04-01 | Bureau | Illinois | 17011 | 8335 | 140 |
2363462 | 2363462 | 2022-04-01 | Grundy | Illinois | 17063 | 12616 | 140 |
2360182 | 2360182 | 2022-03-31 | Bureau | Illinois | 17011 | 8336 | 140 |
2360208 | 2360208 | 2022-03-31 | Grundy | Illinois | 17063 | 12614 | 140 |
2356954 | 2356954 | 2022-03-30 | Grundy | Illinois | 17063 | 12609 | 140 |
2353675 | 2353675 | 2022-03-29 | Bureau | Illinois | 17011 | 8333 | 140 |
2353701 | 2353701 | 2022-03-29 | Grundy | Illinois | 17063 | 12593 | 140 |
2350423 | 2350423 | 2022-03-28 | Bureau | Illinois | 17011 | 8332 | 140 |
2350449 | 2350449 | 2022-03-28 | Grundy | Illinois | 17063 | 12589 | 140 |
2347170 | 2347170 | 2022-03-27 | Bureau | Illinois | 17011 | 8325 | 140 |
2347196 | 2347196 | 2022-03-27 | Grundy | Illinois | 17063 | 12582 | 140 |
2343917 | 2343917 | 2022-03-26 | Bureau | Illinois | 17011 | 8325 | 140 |
2343943 | 2343943 | 2022-03-26 | Grundy | Illinois | 17063 | 12582 | 140 |
2340664 | 2340664 | 2022-03-25 | Bureau | Illinois | 17011 | 8325 | 140 |
2340690 | 2340690 | 2022-03-25 | Grundy | Illinois | 17063 | 12582 | 140 |
2337411 | 2337411 | 2022-03-24 | Bureau | Illinois | 17011 | 8324 | 140 |
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);