ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Monroe" and fips = 42089 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 |
---|---|---|---|---|---|---|---|
2501891 | 2501891 | 2022-05-13 | Monroe | Pennsylvania | 42089 | 37881 | 524 |
2498633 | 2498633 | 2022-05-12 | Monroe | Pennsylvania | 42089 | 37881 | 524 |
2495375 | 2495375 | 2022-05-11 | Monroe | Pennsylvania | 42089 | 37881 | 524 |
2492117 | 2492117 | 2022-05-10 | Monroe | Pennsylvania | 42089 | 37581 | 524 |
2488859 | 2488859 | 2022-05-09 | Monroe | Pennsylvania | 42089 | 37581 | 524 |
2485602 | 2485602 | 2022-05-08 | Monroe | Pennsylvania | 42089 | 37581 | 524 |
2482344 | 2482344 | 2022-05-07 | Monroe | Pennsylvania | 42089 | 37581 | 524 |
2479086 | 2479086 | 2022-05-06 | Monroe | Pennsylvania | 42089 | 37581 | 524 |
2475828 | 2475828 | 2022-05-05 | Monroe | Pennsylvania | 42089 | 37581 | 524 |
2472571 | 2472571 | 2022-05-04 | Monroe | Pennsylvania | 42089 | 37581 | 524 |
2469315 | 2469315 | 2022-05-03 | Monroe | Pennsylvania | 42089 | 37539 | 523 |
2466059 | 2466059 | 2022-05-02 | Monroe | Pennsylvania | 42089 | 37507 | 522 |
2462804 | 2462804 | 2022-05-01 | Monroe | Pennsylvania | 42089 | 37493 | 522 |
2459548 | 2459548 | 2022-04-30 | Monroe | Pennsylvania | 42089 | 37461 | 522 |
2456292 | 2456292 | 2022-04-29 | Monroe | Pennsylvania | 42089 | 37421 | 522 |
2453036 | 2453036 | 2022-04-28 | Monroe | Pennsylvania | 42089 | 37388 | 522 |
2449780 | 2449780 | 2022-04-27 | Monroe | Pennsylvania | 42089 | 37356 | 521 |
2446523 | 2446523 | 2022-04-26 | Monroe | Pennsylvania | 42089 | 37326 | 521 |
2443268 | 2443268 | 2022-04-25 | Monroe | Pennsylvania | 42089 | 37308 | 520 |
2440012 | 2440012 | 2022-04-24 | Monroe | Pennsylvania | 42089 | 37281 | 520 |
2436756 | 2436756 | 2022-04-23 | Monroe | Pennsylvania | 42089 | 37264 | 519 |
2433500 | 2433500 | 2022-04-22 | Monroe | Pennsylvania | 42089 | 37238 | 519 |
2430244 | 2430244 | 2022-04-21 | Monroe | Pennsylvania | 42089 | 37208 | 519 |
2426988 | 2426988 | 2022-04-20 | Monroe | Pennsylvania | 42089 | 37169 | 519 |
2423732 | 2423732 | 2022-04-19 | Monroe | Pennsylvania | 42089 | 37162 | 519 |
2420476 | 2420476 | 2022-04-18 | Monroe | Pennsylvania | 42089 | 37137 | 519 |
2417220 | 2417220 | 2022-04-17 | Monroe | Pennsylvania | 42089 | 37126 | 519 |
2413964 | 2413964 | 2022-04-16 | Monroe | Pennsylvania | 42089 | 37112 | 519 |
2410708 | 2410708 | 2022-04-15 | Monroe | Pennsylvania | 42089 | 37088 | 518 |
2407452 | 2407452 | 2022-04-14 | Monroe | Pennsylvania | 42089 | 37067 | 518 |
2404196 | 2404196 | 2022-04-13 | Monroe | Pennsylvania | 42089 | 37044 | 518 |
2400941 | 2400941 | 2022-04-12 | Monroe | Pennsylvania | 42089 | 37024 | 518 |
2397686 | 2397686 | 2022-04-11 | Monroe | Pennsylvania | 42089 | 37012 | 518 |
2394431 | 2394431 | 2022-04-10 | Monroe | Pennsylvania | 42089 | 37006 | 518 |
2391175 | 2391175 | 2022-04-09 | Monroe | Pennsylvania | 42089 | 36994 | 518 |
2387919 | 2387919 | 2022-04-08 | Monroe | Pennsylvania | 42089 | 36988 | 518 |
2384664 | 2384664 | 2022-04-07 | Monroe | Pennsylvania | 42089 | 36976 | 518 |
2381409 | 2381409 | 2022-04-06 | Monroe | Pennsylvania | 42089 | 36959 | 517 |
2378154 | 2378154 | 2022-04-05 | Monroe | Pennsylvania | 42089 | 36945 | 517 |
2374900 | 2374900 | 2022-04-04 | Monroe | Pennsylvania | 42089 | 36935 | 517 |
2371648 | 2371648 | 2022-04-03 | Monroe | Pennsylvania | 42089 | 36920 | 517 |
2368395 | 2368395 | 2022-04-02 | Monroe | Pennsylvania | 42089 | 36920 | 517 |
2365142 | 2365142 | 2022-04-01 | Monroe | Pennsylvania | 42089 | 36905 | 517 |
2361889 | 2361889 | 2022-03-31 | Monroe | Pennsylvania | 42089 | 36898 | 517 |
2358635 | 2358635 | 2022-03-30 | Monroe | Pennsylvania | 42089 | 36887 | 517 |
2355381 | 2355381 | 2022-03-29 | Monroe | Pennsylvania | 42089 | 36875 | 517 |
2352128 | 2352128 | 2022-03-28 | Monroe | Pennsylvania | 42089 | 36862 | 517 |
2348876 | 2348876 | 2022-03-27 | Monroe | Pennsylvania | 42089 | 36860 | 517 |
2345623 | 2345623 | 2022-03-26 | Monroe | Pennsylvania | 42089 | 36851 | 517 |
2342370 | 2342370 | 2022-03-25 | Monroe | Pennsylvania | 42089 | 36843 | 517 |
2339117 | 2339117 | 2022-03-24 | Monroe | Pennsylvania | 42089 | 36835 | 517 |
2335863 | 2335863 | 2022-03-23 | Monroe | Pennsylvania | 42089 | 36824 | 517 |
2332609 | 2332609 | 2022-03-22 | Monroe | Pennsylvania | 42089 | 36807 | 517 |
2329356 | 2329356 | 2022-03-21 | Monroe | Pennsylvania | 42089 | 36799 | 516 |
2326104 | 2326104 | 2022-03-20 | Monroe | Pennsylvania | 42089 | 36791 | 516 |
2322851 | 2322851 | 2022-03-19 | Monroe | Pennsylvania | 42089 | 36786 | 515 |
2319597 | 2319597 | 2022-03-18 | Monroe | Pennsylvania | 42089 | 36782 | 515 |
2316343 | 2316343 | 2022-03-17 | Monroe | Pennsylvania | 42089 | 36775 | 514 |
2313090 | 2313090 | 2022-03-16 | Monroe | Pennsylvania | 42089 | 36766 | 514 |
2309837 | 2309837 | 2022-03-15 | Monroe | Pennsylvania | 42089 | 36759 | 514 |
2306584 | 2306584 | 2022-03-14 | Monroe | Pennsylvania | 42089 | 36746 | 514 |
2303333 | 2303333 | 2022-03-13 | Monroe | Pennsylvania | 42089 | 36744 | 514 |
2300081 | 2300081 | 2022-03-12 | Monroe | Pennsylvania | 42089 | 36738 | 514 |
2296829 | 2296829 | 2022-03-11 | Monroe | Pennsylvania | 42089 | 36731 | 514 |
2293577 | 2293577 | 2022-03-10 | Monroe | Pennsylvania | 42089 | 36717 | 514 |
2290325 | 2290325 | 2022-03-09 | Monroe | Pennsylvania | 42089 | 36704 | 514 |
2287073 | 2287073 | 2022-03-08 | Monroe | Pennsylvania | 42089 | 36698 | 513 |
2283821 | 2283821 | 2022-03-07 | Monroe | Pennsylvania | 42089 | 36692 | 511 |
2280569 | 2280569 | 2022-03-06 | Monroe | Pennsylvania | 42089 | 36688 | 511 |
2277316 | 2277316 | 2022-03-05 | Monroe | Pennsylvania | 42089 | 36685 | 510 |
2274063 | 2274063 | 2022-03-04 | Monroe | Pennsylvania | 42089 | 36674 | 510 |
2270810 | 2270810 | 2022-03-03 | Monroe | Pennsylvania | 42089 | 36666 | 510 |
2267558 | 2267558 | 2022-03-02 | Monroe | Pennsylvania | 42089 | 36657 | 510 |
2264305 | 2264305 | 2022-03-01 | Monroe | Pennsylvania | 42089 | 36649 | 507 |
2261055 | 2261055 | 2022-02-28 | Monroe | Pennsylvania | 42089 | 36642 | 505 |
2257804 | 2257804 | 2022-02-27 | Monroe | Pennsylvania | 42089 | 36635 | 505 |
2254553 | 2254553 | 2022-02-26 | Monroe | Pennsylvania | 42089 | 36622 | 505 |
2251302 | 2251302 | 2022-02-25 | Monroe | Pennsylvania | 42089 | 36604 | 505 |
2248051 | 2248051 | 2022-02-24 | Monroe | Pennsylvania | 42089 | 36586 | 504 |
2244800 | 2244800 | 2022-02-23 | Monroe | Pennsylvania | 42089 | 36563 | 503 |
2241549 | 2241549 | 2022-02-22 | Monroe | Pennsylvania | 42089 | 36558 | 503 |
2238298 | 2238298 | 2022-02-21 | Monroe | Pennsylvania | 42089 | 36531 | 503 |
2235047 | 2235047 | 2022-02-20 | Monroe | Pennsylvania | 42089 | 36531 | 503 |
2231796 | 2231796 | 2022-02-19 | Monroe | Pennsylvania | 42089 | 36518 | 502 |
2228545 | 2228545 | 2022-02-18 | Monroe | Pennsylvania | 42089 | 36457 | 502 |
2225294 | 2225294 | 2022-02-17 | Monroe | Pennsylvania | 42089 | 36432 | 502 |
2222043 | 2222043 | 2022-02-16 | Monroe | Pennsylvania | 42089 | 36400 | 499 |
2218792 | 2218792 | 2022-02-15 | Monroe | Pennsylvania | 42089 | 36382 | 497 |
2215541 | 2215541 | 2022-02-14 | Monroe | Pennsylvania | 42089 | 36368 | 495 |
2212290 | 2212290 | 2022-02-13 | Monroe | Pennsylvania | 42089 | 36348 | 495 |
2209037 | 2209037 | 2022-02-12 | Monroe | Pennsylvania | 42089 | 36315 | 495 |
2205784 | 2205784 | 2022-02-11 | Monroe | Pennsylvania | 42089 | 36262 | 494 |
2202531 | 2202531 | 2022-02-10 | Monroe | Pennsylvania | 42089 | 36195 | 493 |
2199277 | 2199277 | 2022-02-09 | Monroe | Pennsylvania | 42089 | 36142 | 491 |
2196023 | 2196023 | 2022-02-08 | Monroe | Pennsylvania | 42089 | 36099 | 487 |
2192769 | 2192769 | 2022-02-07 | Monroe | Pennsylvania | 42089 | 36173 | 484 |
2189515 | 2189515 | 2022-02-06 | Monroe | Pennsylvania | 42089 | 36065 | 482 |
2186262 | 2186262 | 2022-02-05 | Monroe | Pennsylvania | 42089 | 36042 | 482 |
2183010 | 2183010 | 2022-02-04 | Monroe | Pennsylvania | 42089 | 35934 | 477 |
2179758 | 2179758 | 2022-02-03 | Monroe | Pennsylvania | 42089 | 35859 | 476 |
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);