ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Monroe" and state = "Illinois" 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 |
---|---|---|---|---|---|---|---|
2500243 | 2500243 | 2022-05-13 | Monroe | Illinois | 17133 | 9633 | 128 |
2496985 | 2496985 | 2022-05-12 | Monroe | Illinois | 17133 | 9621 | 128 |
2493727 | 2493727 | 2022-05-11 | Monroe | Illinois | 17133 | 9612 | 128 |
2490469 | 2490469 | 2022-05-10 | Monroe | Illinois | 17133 | 9607 | 128 |
2487212 | 2487212 | 2022-05-09 | Monroe | Illinois | 17133 | 9599 | 128 |
2483954 | 2483954 | 2022-05-08 | Monroe | Illinois | 17133 | 9575 | 128 |
2480696 | 2480696 | 2022-05-07 | Monroe | Illinois | 17133 | 9575 | 128 |
2477438 | 2477438 | 2022-05-06 | Monroe | Illinois | 17133 | 9575 | 128 |
2474180 | 2474180 | 2022-05-05 | Monroe | Illinois | 17133 | 9568 | 128 |
2470923 | 2470923 | 2022-05-04 | Monroe | Illinois | 17133 | 9569 | 128 |
2467667 | 2467667 | 2022-05-03 | Monroe | Illinois | 17133 | 9563 | 128 |
2464412 | 2464412 | 2022-05-02 | Monroe | Illinois | 17133 | 9558 | 127 |
2461156 | 2461156 | 2022-05-01 | Monroe | Illinois | 17133 | 9545 | 127 |
2457900 | 2457900 | 2022-04-30 | Monroe | Illinois | 17133 | 9545 | 127 |
2454644 | 2454644 | 2022-04-29 | Monroe | Illinois | 17133 | 9545 | 127 |
2451388 | 2451388 | 2022-04-28 | Monroe | Illinois | 17133 | 9543 | 127 |
2448132 | 2448132 | 2022-04-27 | Monroe | Illinois | 17133 | 9533 | 127 |
2444876 | 2444876 | 2022-04-26 | Monroe | Illinois | 17133 | 9528 | 127 |
2441620 | 2441620 | 2022-04-25 | Monroe | Illinois | 17133 | 9526 | 127 |
2438364 | 2438364 | 2022-04-24 | Monroe | Illinois | 17133 | 9518 | 127 |
2435108 | 2435108 | 2022-04-23 | Monroe | Illinois | 17133 | 9518 | 127 |
2431852 | 2431852 | 2022-04-22 | Monroe | Illinois | 17133 | 9518 | 127 |
2428596 | 2428596 | 2022-04-21 | Monroe | Illinois | 17133 | 9512 | 127 |
2425340 | 2425340 | 2022-04-20 | Monroe | Illinois | 17133 | 9507 | 127 |
2422084 | 2422084 | 2022-04-19 | Monroe | Illinois | 17133 | 9504 | 127 |
2418828 | 2418828 | 2022-04-18 | Monroe | Illinois | 17133 | 9498 | 127 |
2415572 | 2415572 | 2022-04-17 | Monroe | Illinois | 17133 | 9496 | 127 |
2412316 | 2412316 | 2022-04-16 | Monroe | Illinois | 17133 | 9496 | 127 |
2409060 | 2409060 | 2022-04-15 | Monroe | Illinois | 17133 | 9496 | 127 |
2405804 | 2405804 | 2022-04-14 | Monroe | Illinois | 17133 | 9492 | 127 |
2402549 | 2402549 | 2022-04-13 | Monroe | Illinois | 17133 | 9489 | 127 |
2399294 | 2399294 | 2022-04-12 | Monroe | Illinois | 17133 | 9489 | 127 |
2396039 | 2396039 | 2022-04-11 | Monroe | Illinois | 17133 | 9487 | 127 |
2392783 | 2392783 | 2022-04-10 | Monroe | Illinois | 17133 | 9486 | 127 |
2389527 | 2389527 | 2022-04-09 | Monroe | Illinois | 17133 | 9486 | 127 |
2386272 | 2386272 | 2022-04-08 | Monroe | Illinois | 17133 | 9486 | 127 |
2383017 | 2383017 | 2022-04-07 | Monroe | Illinois | 17133 | 9482 | 127 |
2379762 | 2379762 | 2022-04-06 | Monroe | Illinois | 17133 | 9481 | 127 |
2376508 | 2376508 | 2022-04-05 | Monroe | Illinois | 17133 | 9479 | 127 |
2373256 | 2373256 | 2022-04-04 | Monroe | Illinois | 17133 | 9473 | 127 |
2370003 | 2370003 | 2022-04-03 | Monroe | Illinois | 17133 | 9467 | 127 |
2366750 | 2366750 | 2022-04-02 | Monroe | Illinois | 17133 | 9467 | 127 |
2363497 | 2363497 | 2022-04-01 | Monroe | Illinois | 17133 | 9467 | 127 |
2360243 | 2360243 | 2022-03-31 | Monroe | Illinois | 17133 | 9465 | 127 |
2356989 | 2356989 | 2022-03-30 | Monroe | Illinois | 17133 | 9463 | 127 |
2353736 | 2353736 | 2022-03-29 | Monroe | Illinois | 17133 | 9455 | 127 |
2350484 | 2350484 | 2022-03-28 | Monroe | Illinois | 17133 | 9451 | 127 |
2347231 | 2347231 | 2022-03-27 | Monroe | Illinois | 17133 | 9451 | 127 |
2343978 | 2343978 | 2022-03-26 | Monroe | Illinois | 17133 | 9451 | 127 |
2340725 | 2340725 | 2022-03-25 | Monroe | Illinois | 17133 | 9451 | 127 |
2337472 | 2337472 | 2022-03-24 | Monroe | Illinois | 17133 | 9451 | 127 |
2334218 | 2334218 | 2022-03-23 | Monroe | Illinois | 17133 | 9449 | 127 |
2330964 | 2330964 | 2022-03-22 | Monroe | Illinois | 17133 | 9446 | 127 |
2327712 | 2327712 | 2022-03-21 | Monroe | Illinois | 17133 | 9440 | 127 |
2324459 | 2324459 | 2022-03-20 | Monroe | Illinois | 17133 | 9436 | 127 |
2321205 | 2321205 | 2022-03-19 | Monroe | Illinois | 17133 | 9436 | 127 |
2317951 | 2317951 | 2022-03-18 | Monroe | Illinois | 17133 | 9436 | 127 |
2314698 | 2314698 | 2022-03-17 | Monroe | Illinois | 17133 | 9431 | 127 |
2311445 | 2311445 | 2022-03-16 | Monroe | Illinois | 17133 | 9448 | 127 |
2308192 | 2308192 | 2022-03-15 | Monroe | Illinois | 17133 | 9447 | 127 |
2304941 | 2304941 | 2022-03-14 | Monroe | Illinois | 17133 | 9445 | 127 |
2301689 | 2301689 | 2022-03-13 | Monroe | Illinois | 17133 | 9441 | 128 |
2298437 | 2298437 | 2022-03-12 | Monroe | Illinois | 17133 | 9441 | 128 |
2295185 | 2295185 | 2022-03-11 | Monroe | Illinois | 17133 | 9441 | 128 |
2291933 | 2291933 | 2022-03-10 | Monroe | Illinois | 17133 | 9437 | 129 |
2288681 | 2288681 | 2022-03-09 | Monroe | Illinois | 17133 | 9436 | 130 |
2285430 | 2285430 | 2022-03-08 | Monroe | Illinois | 17133 | 9435 | 130 |
2282178 | 2282178 | 2022-03-07 | Monroe | Illinois | 17133 | 9432 | 130 |
2278925 | 2278925 | 2022-03-06 | Monroe | Illinois | 17133 | 9430 | 131 |
2275672 | 2275672 | 2022-03-05 | Monroe | Illinois | 17133 | 9430 | 131 |
2272419 | 2272419 | 2022-03-04 | Monroe | Illinois | 17133 | 9430 | 131 |
2269167 | 2269167 | 2022-03-03 | Monroe | Illinois | 17133 | 9425 | 131 |
2265914 | 2265914 | 2022-03-02 | Monroe | Illinois | 17133 | 9421 | 131 |
2262663 | 2262663 | 2022-03-01 | Monroe | Illinois | 17133 | 9417 | 131 |
2259412 | 2259412 | 2022-02-28 | Monroe | Illinois | 17133 | 9413 | 131 |
2256161 | 2256161 | 2022-02-27 | Monroe | Illinois | 17133 | 9407 | 131 |
2252910 | 2252910 | 2022-02-26 | Monroe | Illinois | 17133 | 9407 | 131 |
2249659 | 2249659 | 2022-02-25 | Monroe | Illinois | 17133 | 9407 | 131 |
2246408 | 2246408 | 2022-02-24 | Monroe | Illinois | 17133 | 9403 | 131 |
2243157 | 2243157 | 2022-02-23 | Monroe | Illinois | 17133 | 9397 | 131 |
2239906 | 2239906 | 2022-02-22 | Monroe | Illinois | 17133 | 9385 | 130 |
2236655 | 2236655 | 2022-02-21 | Monroe | Illinois | 17133 | 9368 | 130 |
2233404 | 2233404 | 2022-02-20 | Monroe | Illinois | 17133 | 9368 | 130 |
2230153 | 2230153 | 2022-02-19 | Monroe | Illinois | 17133 | 9368 | 130 |
2226902 | 2226902 | 2022-02-18 | Monroe | Illinois | 17133 | 9368 | 130 |
2223651 | 2223651 | 2022-02-17 | Monroe | Illinois | 17133 | 9349 | 129 |
2220400 | 2220400 | 2022-02-16 | Monroe | Illinois | 17133 | 9327 | 128 |
2217149 | 2217149 | 2022-02-15 | Monroe | Illinois | 17133 | 9300 | 127 |
2213898 | 2213898 | 2022-02-14 | Monroe | Illinois | 17133 | 9279 | 126 |
2210646 | 2210646 | 2022-02-13 | Monroe | Illinois | 17133 | 9264 | 122 |
2207393 | 2207393 | 2022-02-12 | Monroe | Illinois | 17133 | 9264 | 122 |
2204140 | 2204140 | 2022-02-11 | Monroe | Illinois | 17133 | 9264 | 122 |
2200887 | 2200887 | 2022-02-10 | Monroe | Illinois | 17133 | 9264 | 122 |
2197633 | 2197633 | 2022-02-09 | Monroe | Illinois | 17133 | 9256 | 122 |
2194379 | 2194379 | 2022-02-08 | Monroe | Illinois | 17133 | 9241 | 122 |
2191125 | 2191125 | 2022-02-07 | Monroe | Illinois | 17133 | 9218 | 121 |
2187872 | 2187872 | 2022-02-06 | Monroe | Illinois | 17133 | 9178 | 121 |
2184619 | 2184619 | 2022-02-05 | Monroe | Illinois | 17133 | 9178 | 121 |
2181367 | 2181367 | 2022-02-04 | Monroe | Illinois | 17133 | 9178 | 121 |
2178116 | 2178116 | 2022-02-03 | Monroe | Illinois | 17133 | 9150 | 120 |
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);