ny_times_us_counties

Table actions
⚠️ 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 = "Orange" and state = "Indiana" 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

county 1

  • Orange · 779 ✖
Link rowid date ▲ county state fips cases deaths
2500338 2500338 2022-05-13 Orange Indiana 18117 5051 96
2497080 2497080 2022-05-12 Orange Indiana 18117 5051 96
2493822 2493822 2022-05-11 Orange Indiana 18117 5051 96
2490564 2490564 2022-05-10 Orange Indiana 18117 5048 96
2487307 2487307 2022-05-09 Orange Indiana 18117 5048 96
2484049 2484049 2022-05-08 Orange Indiana 18117 5049 96
2480791 2480791 2022-05-07 Orange Indiana 18117 5049 96
2477533 2477533 2022-05-06 Orange Indiana 18117 5049 96
2474275 2474275 2022-05-05 Orange Indiana 18117 5049 96
2471018 2471018 2022-05-04 Orange Indiana 18117 5049 96
2467762 2467762 2022-05-03 Orange Indiana 18117 5047 96
2464507 2464507 2022-05-02 Orange Indiana 18117 5047 96
2461251 2461251 2022-05-01 Orange Indiana 18117 5045 96
2457995 2457995 2022-04-30 Orange Indiana 18117 5045 96
2454739 2454739 2022-04-29 Orange Indiana 18117 5045 96
2451483 2451483 2022-04-28 Orange Indiana 18117 5042 96
2448227 2448227 2022-04-27 Orange Indiana 18117 5042 96
2444971 2444971 2022-04-26 Orange Indiana 18117 5038 96
2441715 2441715 2022-04-25 Orange Indiana 18117 5038 96
2438459 2438459 2022-04-24 Orange Indiana 18117 5035 96
2435203 2435203 2022-04-23 Orange Indiana 18117 5035 96
2431947 2431947 2022-04-22 Orange Indiana 18117 5035 96
2428691 2428691 2022-04-21 Orange Indiana 18117 5034 96
2425435 2425435 2022-04-20 Orange Indiana 18117 5034 96
2422179 2422179 2022-04-19 Orange Indiana 18117 5034 96
2418923 2418923 2022-04-18 Orange Indiana 18117 5034 96
2415667 2415667 2022-04-17 Orange Indiana 18117 5032 96
2412411 2412411 2022-04-16 Orange Indiana 18117 5032 96
2409155 2409155 2022-04-15 Orange Indiana 18117 5032 96
2405899 2405899 2022-04-14 Orange Indiana 18117 5032 96
2402644 2402644 2022-04-13 Orange Indiana 18117 5032 96
2399389 2399389 2022-04-12 Orange Indiana 18117 5032 96
2396134 2396134 2022-04-11 Orange Indiana 18117 5032 96
2392878 2392878 2022-04-10 Orange Indiana 18117 5031 96
2389622 2389622 2022-04-09 Orange Indiana 18117 5031 96
2386367 2386367 2022-04-08 Orange Indiana 18117 5031 96
2383112 2383112 2022-04-07 Orange Indiana 18117 5029 96
2379857 2379857 2022-04-06 Orange Indiana 18117 5029 96
2376603 2376603 2022-04-05 Orange Indiana 18117 5030 96
2373351 2373351 2022-04-04 Orange Indiana 18117 5030 96
2370098 2370098 2022-04-03 Orange Indiana 18117 5029 96
2366845 2366845 2022-04-02 Orange Indiana 18117 5029 96
2363592 2363592 2022-04-01 Orange Indiana 18117 5029 96
2360338 2360338 2022-03-31 Orange Indiana 18117 5028 96
2357084 2357084 2022-03-30 Orange Indiana 18117 5028 96
2353831 2353831 2022-03-29 Orange Indiana 18117 5035 96
2350579 2350579 2022-03-28 Orange Indiana 18117 5035 96
2347326 2347326 2022-03-27 Orange Indiana 18117 5033 96
2344073 2344073 2022-03-26 Orange Indiana 18117 5033 96
2340820 2340820 2022-03-25 Orange Indiana 18117 5033 96
2337567 2337567 2022-03-24 Orange Indiana 18117 5033 96
2334313 2334313 2022-03-23 Orange Indiana 18117 5032 96
2331059 2331059 2022-03-22 Orange Indiana 18117 5032 96
2327807 2327807 2022-03-21 Orange Indiana 18117 5032 96
2324554 2324554 2022-03-20 Orange Indiana 18117 5031 96
2321300 2321300 2022-03-19 Orange Indiana 18117 5031 96
2318046 2318046 2022-03-18 Orange Indiana 18117 5031 96
2314793 2314793 2022-03-17 Orange Indiana 18117 5031 96
2311540 2311540 2022-03-16 Orange Indiana 18117 5028 96
2308287 2308287 2022-03-15 Orange Indiana 18117 5028 96
2305036 2305036 2022-03-14 Orange Indiana 18117 5028 96
2301784 2301784 2022-03-13 Orange Indiana 18117 5027 96
2298532 2298532 2022-03-12 Orange Indiana 18117 5027 96
2295280 2295280 2022-03-11 Orange Indiana 18117 5027 96
2292028 2292028 2022-03-10 Orange Indiana 18117 5027 96
2288776 2288776 2022-03-09 Orange Indiana 18117 5027 96
2285525 2285525 2022-03-08 Orange Indiana 18117 5026 96
2282273 2282273 2022-03-07 Orange Indiana 18117 5025 96
2279020 2279020 2022-03-06 Orange Indiana 18117 5021 94
2275767 2275767 2022-03-05 Orange Indiana 18117 5021 94
2272514 2272514 2022-03-04 Orange Indiana 18117 5021 94
2269262 2269262 2022-03-03 Orange Indiana 18117 5020 94
2266009 2266009 2022-03-02 Orange Indiana 18117 5017 94
2262758 2262758 2022-03-01 Orange Indiana 18117 5017 93
2259507 2259507 2022-02-28 Orange Indiana 18117 5017 93
2256256 2256256 2022-02-27 Orange Indiana 18117 5012 93
2253005 2253005 2022-02-26 Orange Indiana 18117 5012 93
2249754 2249754 2022-02-25 Orange Indiana 18117 5012 93
2246503 2246503 2022-02-24 Orange Indiana 18117 5012 92
2243252 2243252 2022-02-23 Orange Indiana 18117 5008 92
2240001 2240001 2022-02-22 Orange Indiana 18117 5005 92
2236750 2236750 2022-02-21 Orange Indiana 18117 5003 92
2233499 2233499 2022-02-20 Orange Indiana 18117 4994 92
2230248 2230248 2022-02-19 Orange Indiana 18117 4994 92
2226997 2226997 2022-02-18 Orange Indiana 18117 4994 92
2223746 2223746 2022-02-17 Orange Indiana 18117 4987 92
2220495 2220495 2022-02-16 Orange Indiana 18117 4979 92
2217244 2217244 2022-02-15 Orange Indiana 18117 4974 92
2213993 2213993 2022-02-14 Orange Indiana 18117 4972 92
2210741 2210741 2022-02-13 Orange Indiana 18117 4955 92
2207488 2207488 2022-02-12 Orange Indiana 18117 4955 92
2204235 2204235 2022-02-11 Orange Indiana 18117 4955 92
2200982 2200982 2022-02-10 Orange Indiana 18117 4939 92
2197728 2197728 2022-02-09 Orange Indiana 18117 4910 92
2194474 2194474 2022-02-08 Orange Indiana 18117 4910 92
2191220 2191220 2022-02-07 Orange Indiana 18117 4898 92
2187967 2187967 2022-02-06 Orange Indiana 18117 4874 91
2184714 2184714 2022-02-05 Orange Indiana 18117 4874 91
2181462 2181462 2022-02-04 Orange Indiana 18117 4874 91
2178211 2178211 2022-02-03 Orange Indiana 18117 4848 91

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);