home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

741 rows where county = "Monroe" and fips = 19135 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Iowa 741

fips 1

  • 19135 · 741 ✖

county 1

  • Monroe · 741 ✖
Link rowid date ▲ county state fips cases deaths
2500440 2500440 2022-05-13 Monroe Iowa 19135 1882 49
2497182 2497182 2022-05-12 Monroe Iowa 19135 1882 49
2493924 2493924 2022-05-11 Monroe Iowa 19135 1882 49
2490666 2490666 2022-05-10 Monroe Iowa 19135 1882 49
2487409 2487409 2022-05-09 Monroe Iowa 19135 1882 49
2484151 2484151 2022-05-08 Monroe Iowa 19135 1882 49
2480893 2480893 2022-05-07 Monroe Iowa 19135 1882 49
2477635 2477635 2022-05-06 Monroe Iowa 19135 1882 49
2474377 2474377 2022-05-05 Monroe Iowa 19135 1882 49
2471120 2471120 2022-05-04 Monroe Iowa 19135 1882 49
2467864 2467864 2022-05-03 Monroe Iowa 19135 1882 49
2464609 2464609 2022-05-02 Monroe Iowa 19135 1882 49
2461353 2461353 2022-05-01 Monroe Iowa 19135 1882 49
2458097 2458097 2022-04-30 Monroe Iowa 19135 1882 49
2454841 2454841 2022-04-29 Monroe Iowa 19135 1882 49
2451585 2451585 2022-04-28 Monroe Iowa 19135 1882 49
2448329 2448329 2022-04-27 Monroe Iowa 19135 1882 49
2445073 2445073 2022-04-26 Monroe Iowa 19135 1882 49
2441817 2441817 2022-04-25 Monroe Iowa 19135 1882 49
2438561 2438561 2022-04-24 Monroe Iowa 19135 1882 49
2435305 2435305 2022-04-23 Monroe Iowa 19135 1882 49
2432049 2432049 2022-04-22 Monroe Iowa 19135 1882 49
2428793 2428793 2022-04-21 Monroe Iowa 19135 1882 49
2425537 2425537 2022-04-20 Monroe Iowa 19135 1882 49
2422281 2422281 2022-04-19 Monroe Iowa 19135 1879 49
2419025 2419025 2022-04-18 Monroe Iowa 19135 1879 49
2415769 2415769 2022-04-17 Monroe Iowa 19135 1879 49
2412513 2412513 2022-04-16 Monroe Iowa 19135 1879 49
2409257 2409257 2022-04-15 Monroe Iowa 19135 1879 49
2406001 2406001 2022-04-14 Monroe Iowa 19135 1879 49
2402745 2402745 2022-04-13 Monroe Iowa 19135 1879 49
2399491 2399491 2022-04-12 Monroe Iowa 19135 1879 49
2396235 2396235 2022-04-11 Monroe Iowa 19135 1879 49
2392980 2392980 2022-04-10 Monroe Iowa 19135 1879 49
2389724 2389724 2022-04-09 Monroe Iowa 19135 1879 49
2386468 2386468 2022-04-08 Monroe Iowa 19135 1879 49
2383214 2383214 2022-04-07 Monroe Iowa 19135 1879 49
2379959 2379959 2022-04-06 Monroe Iowa 19135 1879 49
2376704 2376704 2022-04-05 Monroe Iowa 19135 1874 49
2373452 2373452 2022-04-04 Monroe Iowa 19135 1874 49
2370199 2370199 2022-04-03 Monroe Iowa 19135 1874 49
2366946 2366946 2022-04-02 Monroe Iowa 19135 1874 49
2363693 2363693 2022-04-01 Monroe Iowa 19135 1874 49
2360439 2360439 2022-03-31 Monroe Iowa 19135 1874 49
2357185 2357185 2022-03-30 Monroe Iowa 19135 1874 49
2353932 2353932 2022-03-29 Monroe Iowa 19135 1875 48
2350680 2350680 2022-03-28 Monroe Iowa 19135 1875 48
2347427 2347427 2022-03-27 Monroe Iowa 19135 1875 48
2344174 2344174 2022-03-26 Monroe Iowa 19135 1875 48
2340921 2340921 2022-03-25 Monroe Iowa 19135 1875 48
2337668 2337668 2022-03-24 Monroe Iowa 19135 1875 48
2334414 2334414 2022-03-23 Monroe Iowa 19135 1875 48
2331160 2331160 2022-03-22 Monroe Iowa 19135 1875 48
2327908 2327908 2022-03-21 Monroe Iowa 19135 1875 48
2324655 2324655 2022-03-20 Monroe Iowa 19135 1875 48
2321401 2321401 2022-03-19 Monroe Iowa 19135 1875 48
2318147 2318147 2022-03-18 Monroe Iowa 19135 1875 48
2314894 2314894 2022-03-17 Monroe Iowa 19135 1875 48
2311641 2311641 2022-03-16 Monroe Iowa 19135 1878 48
2308388 2308388 2022-03-15 Monroe Iowa 19135 1878 48
2305137 2305137 2022-03-14 Monroe Iowa 19135 1878 48
2301885 2301885 2022-03-13 Monroe Iowa 19135 1878 48
2298633 2298633 2022-03-12 Monroe Iowa 19135 1878 48
2295381 2295381 2022-03-11 Monroe Iowa 19135 1878 48
2292129 2292129 2022-03-10 Monroe Iowa 19135 1878 48
2288877 2288877 2022-03-09 Monroe Iowa 19135 1878 48
2285626 2285626 2022-03-08 Monroe Iowa 19135 1875 48
2282374 2282374 2022-03-07 Monroe Iowa 19135 1875 48
2279121 2279121 2022-03-06 Monroe Iowa 19135 1875 48
2275868 2275868 2022-03-05 Monroe Iowa 19135 1875 48
2272615 2272615 2022-03-04 Monroe Iowa 19135 1875 48
2269363 2269363 2022-03-03 Monroe Iowa 19135 1875 48
2266110 2266110 2022-03-02 Monroe Iowa 19135 1875 48
2262859 2262859 2022-03-01 Monroe Iowa 19135 1867 48
2259608 2259608 2022-02-28 Monroe Iowa 19135 1867 48
2256357 2256357 2022-02-27 Monroe Iowa 19135 1867 48
2253106 2253106 2022-02-26 Monroe Iowa 19135 1867 48
2249855 2249855 2022-02-25 Monroe Iowa 19135 1867 48
2246604 2246604 2022-02-24 Monroe Iowa 19135 1867 48
2243353 2243353 2022-02-23 Monroe Iowa 19135 1867 48
2240102 2240102 2022-02-22 Monroe Iowa 19135 1862 48
2236851 2236851 2022-02-21 Monroe Iowa 19135 1862 48
2233600 2233600 2022-02-20 Monroe Iowa 19135 1862 48
2230349 2230349 2022-02-19 Monroe Iowa 19135 1862 48
2227098 2227098 2022-02-18 Monroe Iowa 19135 1862 48
2223847 2223847 2022-02-17 Monroe Iowa 19135 1862 48
2220596 2220596 2022-02-16 Monroe Iowa 19135 1862 48
2217345 2217345 2022-02-15 Monroe Iowa 19135 1840 47
2214094 2214094 2022-02-14 Monroe Iowa 19135 1840 47
2210842 2210842 2022-02-13 Monroe Iowa 19135 1840 47
2207589 2207589 2022-02-12 Monroe Iowa 19135 1840 47
2204336 2204336 2022-02-11 Monroe Iowa 19135 1840 47
2201083 2201083 2022-02-10 Monroe Iowa 19135 1840 47
2197829 2197829 2022-02-09 Monroe Iowa 19135 1840 47
2194575 2194575 2022-02-08 Monroe Iowa 19135 1806 46
2191321 2191321 2022-02-07 Monroe Iowa 19135 1806 46
2188068 2188068 2022-02-06 Monroe Iowa 19135 1806 46
2184815 2184815 2022-02-05 Monroe Iowa 19135 1806 46
2181563 2181563 2022-02-04 Monroe Iowa 19135 1806 46
2178312 2178312 2022-02-03 Monroe Iowa 19135 1806 46

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 55.007ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette