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

779 rows where county = "Warren" and fips = 18171 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana 779

fips 1

  • 18171 · 779 ✖

county 1

  • Warren · 779 ✖
Link rowid date ▲ county state fips cases deaths
2500366 2500366 2022-05-13 Warren Indiana 18171 2109 30
2497108 2497108 2022-05-12 Warren Indiana 18171 2109 30
2493850 2493850 2022-05-11 Warren Indiana 18171 2109 30
2490592 2490592 2022-05-10 Warren Indiana 18171 2107 30
2487335 2487335 2022-05-09 Warren Indiana 18171 2107 30
2484077 2484077 2022-05-08 Warren Indiana 18171 2107 30
2480819 2480819 2022-05-07 Warren Indiana 18171 2107 30
2477561 2477561 2022-05-06 Warren Indiana 18171 2107 30
2474303 2474303 2022-05-05 Warren Indiana 18171 2107 30
2471046 2471046 2022-05-04 Warren Indiana 18171 2107 30
2467790 2467790 2022-05-03 Warren Indiana 18171 2103 30
2464535 2464535 2022-05-02 Warren Indiana 18171 2103 30
2461279 2461279 2022-05-01 Warren Indiana 18171 2102 30
2458023 2458023 2022-04-30 Warren Indiana 18171 2102 30
2454767 2454767 2022-04-29 Warren Indiana 18171 2102 30
2451511 2451511 2022-04-28 Warren Indiana 18171 2101 30
2448255 2448255 2022-04-27 Warren Indiana 18171 2101 30
2444999 2444999 2022-04-26 Warren Indiana 18171 2096 30
2441743 2441743 2022-04-25 Warren Indiana 18171 2096 30
2438487 2438487 2022-04-24 Warren Indiana 18171 2094 30
2435231 2435231 2022-04-23 Warren Indiana 18171 2094 30
2431975 2431975 2022-04-22 Warren Indiana 18171 2094 30
2428719 2428719 2022-04-21 Warren Indiana 18171 2093 30
2425463 2425463 2022-04-20 Warren Indiana 18171 2093 30
2422207 2422207 2022-04-19 Warren Indiana 18171 2091 30
2418951 2418951 2022-04-18 Warren Indiana 18171 2091 30
2415695 2415695 2022-04-17 Warren Indiana 18171 2091 30
2412439 2412439 2022-04-16 Warren Indiana 18171 2091 30
2409183 2409183 2022-04-15 Warren Indiana 18171 2091 30
2405927 2405927 2022-04-14 Warren Indiana 18171 2091 30
2402671 2402671 2022-04-13 Warren Indiana 18171 2091 30
2399417 2399417 2022-04-12 Warren Indiana 18171 2090 30
2396161 2396161 2022-04-11 Warren Indiana 18171 2090 30
2392906 2392906 2022-04-10 Warren Indiana 18171 2090 30
2389650 2389650 2022-04-09 Warren Indiana 18171 2090 30
2386394 2386394 2022-04-08 Warren Indiana 18171 2090 30
2383140 2383140 2022-04-07 Warren Indiana 18171 2090 30
2379885 2379885 2022-04-06 Warren Indiana 18171 2090 30
2376630 2376630 2022-04-05 Warren Indiana 18171 2090 30
2373378 2373378 2022-04-04 Warren Indiana 18171 2090 30
2370125 2370125 2022-04-03 Warren Indiana 18171 2090 30
2366872 2366872 2022-04-02 Warren Indiana 18171 2090 30
2363619 2363619 2022-04-01 Warren Indiana 18171 2090 30
2360365 2360365 2022-03-31 Warren Indiana 18171 2087 30
2357111 2357111 2022-03-30 Warren Indiana 18171 2087 30
2353858 2353858 2022-03-29 Warren Indiana 18171 2089 30
2350606 2350606 2022-03-28 Warren Indiana 18171 2083 30
2347353 2347353 2022-03-27 Warren Indiana 18171 2083 30
2344100 2344100 2022-03-26 Warren Indiana 18171 2083 30
2340847 2340847 2022-03-25 Warren Indiana 18171 2083 30
2337594 2337594 2022-03-24 Warren Indiana 18171 2083 30
2334340 2334340 2022-03-23 Warren Indiana 18171 2082 30
2331086 2331086 2022-03-22 Warren Indiana 18171 2077 30
2327834 2327834 2022-03-21 Warren Indiana 18171 2077 30
2324581 2324581 2022-03-20 Warren Indiana 18171 2077 30
2321327 2321327 2022-03-19 Warren Indiana 18171 2077 30
2318073 2318073 2022-03-18 Warren Indiana 18171 2077 30
2314820 2314820 2022-03-17 Warren Indiana 18171 2077 29
2311567 2311567 2022-03-16 Warren Indiana 18171 2076 29
2308314 2308314 2022-03-15 Warren Indiana 18171 2076 29
2305063 2305063 2022-03-14 Warren Indiana 18171 2076 29
2301811 2301811 2022-03-13 Warren Indiana 18171 2076 29
2298559 2298559 2022-03-12 Warren Indiana 18171 2076 29
2295307 2295307 2022-03-11 Warren Indiana 18171 2076 29
2292055 2292055 2022-03-10 Warren Indiana 18171 2076 29
2288803 2288803 2022-03-09 Warren Indiana 18171 2076 29
2285552 2285552 2022-03-08 Warren Indiana 18171 2076 28
2282300 2282300 2022-03-07 Warren Indiana 18171 2073 27
2279047 2279047 2022-03-06 Warren Indiana 18171 2072 27
2275794 2275794 2022-03-05 Warren Indiana 18171 2072 27
2272541 2272541 2022-03-04 Warren Indiana 18171 2072 27
2269289 2269289 2022-03-03 Warren Indiana 18171 2065 26
2266036 2266036 2022-03-02 Warren Indiana 18171 2064 26
2262785 2262785 2022-03-01 Warren Indiana 18171 2063 26
2259534 2259534 2022-02-28 Warren Indiana 18171 2062 25
2256283 2256283 2022-02-27 Warren Indiana 18171 2056 25
2253032 2253032 2022-02-26 Warren Indiana 18171 2056 25
2249781 2249781 2022-02-25 Warren Indiana 18171 2056 25
2246530 2246530 2022-02-24 Warren Indiana 18171 2054 25
2243279 2243279 2022-02-23 Warren Indiana 18171 2054 25
2240028 2240028 2022-02-22 Warren Indiana 18171 2051 25
2236777 2236777 2022-02-21 Warren Indiana 18171 2050 25
2233526 2233526 2022-02-20 Warren Indiana 18171 2046 25
2230275 2230275 2022-02-19 Warren Indiana 18171 2046 25
2227024 2227024 2022-02-18 Warren Indiana 18171 2046 25
2223773 2223773 2022-02-17 Warren Indiana 18171 2044 25
2220522 2220522 2022-02-16 Warren Indiana 18171 2041 25
2217271 2217271 2022-02-15 Warren Indiana 18171 2036 24
2214020 2214020 2022-02-14 Warren Indiana 18171 2032 24
2210768 2210768 2022-02-13 Warren Indiana 18171 2024 24
2207515 2207515 2022-02-12 Warren Indiana 18171 2024 24
2204262 2204262 2022-02-11 Warren Indiana 18171 2024 24
2201009 2201009 2022-02-10 Warren Indiana 18171 2014 24
2197755 2197755 2022-02-09 Warren Indiana 18171 2012 24
2194501 2194501 2022-02-08 Warren Indiana 18171 2012 24
2191247 2191247 2022-02-07 Warren Indiana 18171 2008 24
2187994 2187994 2022-02-06 Warren Indiana 18171 2006 24
2184741 2184741 2022-02-05 Warren Indiana 18171 2006 24
2181489 2181489 2022-02-04 Warren Indiana 18171 2006 24
2178238 2178238 2022-02-03 Warren Indiana 18171 2006 24

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 223.362ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette