ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Blackford" and state = "Indiana" 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 |
---|---|---|---|---|---|---|---|
2500284 | 2500284 | 2022-05-13 | Blackford | Indiana | 18009 | 3118 | 69 |
2497026 | 2497026 | 2022-05-12 | Blackford | Indiana | 18009 | 3116 | 69 |
2493768 | 2493768 | 2022-05-11 | Blackford | Indiana | 18009 | 3116 | 69 |
2490510 | 2490510 | 2022-05-10 | Blackford | Indiana | 18009 | 3118 | 69 |
2487253 | 2487253 | 2022-05-09 | Blackford | Indiana | 18009 | 3118 | 69 |
2483995 | 2483995 | 2022-05-08 | Blackford | Indiana | 18009 | 3115 | 69 |
2480737 | 2480737 | 2022-05-07 | Blackford | Indiana | 18009 | 3115 | 69 |
2477479 | 2477479 | 2022-05-06 | Blackford | Indiana | 18009 | 3115 | 69 |
2474221 | 2474221 | 2022-05-05 | Blackford | Indiana | 18009 | 3115 | 69 |
2470964 | 2470964 | 2022-05-04 | Blackford | Indiana | 18009 | 3115 | 69 |
2467708 | 2467708 | 2022-05-03 | Blackford | Indiana | 18009 | 3115 | 69 |
2464453 | 2464453 | 2022-05-02 | Blackford | Indiana | 18009 | 3115 | 69 |
2461197 | 2461197 | 2022-05-01 | Blackford | Indiana | 18009 | 3115 | 69 |
2457941 | 2457941 | 2022-04-30 | Blackford | Indiana | 18009 | 3115 | 69 |
2454685 | 2454685 | 2022-04-29 | Blackford | Indiana | 18009 | 3115 | 69 |
2451429 | 2451429 | 2022-04-28 | Blackford | Indiana | 18009 | 3113 | 69 |
2448173 | 2448173 | 2022-04-27 | Blackford | Indiana | 18009 | 3113 | 69 |
2444917 | 2444917 | 2022-04-26 | Blackford | Indiana | 18009 | 3109 | 69 |
2441661 | 2441661 | 2022-04-25 | Blackford | Indiana | 18009 | 3109 | 69 |
2438405 | 2438405 | 2022-04-24 | Blackford | Indiana | 18009 | 3109 | 69 |
2435149 | 2435149 | 2022-04-23 | Blackford | Indiana | 18009 | 3109 | 69 |
2431893 | 2431893 | 2022-04-22 | Blackford | Indiana | 18009 | 3109 | 69 |
2428637 | 2428637 | 2022-04-21 | Blackford | Indiana | 18009 | 3109 | 69 |
2425381 | 2425381 | 2022-04-20 | Blackford | Indiana | 18009 | 3109 | 69 |
2422125 | 2422125 | 2022-04-19 | Blackford | Indiana | 18009 | 3107 | 69 |
2418869 | 2418869 | 2022-04-18 | Blackford | Indiana | 18009 | 3107 | 69 |
2415613 | 2415613 | 2022-04-17 | Blackford | Indiana | 18009 | 3107 | 69 |
2412357 | 2412357 | 2022-04-16 | Blackford | Indiana | 18009 | 3107 | 69 |
2409101 | 2409101 | 2022-04-15 | Blackford | Indiana | 18009 | 3107 | 69 |
2405845 | 2405845 | 2022-04-14 | Blackford | Indiana | 18009 | 3107 | 69 |
2402590 | 2402590 | 2022-04-13 | Blackford | Indiana | 18009 | 3107 | 69 |
2399335 | 2399335 | 2022-04-12 | Blackford | Indiana | 18009 | 3107 | 69 |
2396080 | 2396080 | 2022-04-11 | Blackford | Indiana | 18009 | 3107 | 69 |
2392824 | 2392824 | 2022-04-10 | Blackford | Indiana | 18009 | 3107 | 69 |
2389568 | 2389568 | 2022-04-09 | Blackford | Indiana | 18009 | 3107 | 69 |
2386313 | 2386313 | 2022-04-08 | Blackford | Indiana | 18009 | 3107 | 69 |
2383058 | 2383058 | 2022-04-07 | Blackford | Indiana | 18009 | 3107 | 69 |
2379803 | 2379803 | 2022-04-06 | Blackford | Indiana | 18009 | 3107 | 69 |
2376549 | 2376549 | 2022-04-05 | Blackford | Indiana | 18009 | 3107 | 69 |
2373297 | 2373297 | 2022-04-04 | Blackford | Indiana | 18009 | 3107 | 69 |
2370044 | 2370044 | 2022-04-03 | Blackford | Indiana | 18009 | 3107 | 69 |
2366791 | 2366791 | 2022-04-02 | Blackford | Indiana | 18009 | 3107 | 69 |
2363538 | 2363538 | 2022-04-01 | Blackford | Indiana | 18009 | 3107 | 69 |
2360284 | 2360284 | 2022-03-31 | Blackford | Indiana | 18009 | 3107 | 69 |
2357030 | 2357030 | 2022-03-30 | Blackford | Indiana | 18009 | 3107 | 69 |
2353777 | 2353777 | 2022-03-29 | Blackford | Indiana | 18009 | 3122 | 69 |
2350525 | 2350525 | 2022-03-28 | Blackford | Indiana | 18009 | 3122 | 69 |
2347272 | 2347272 | 2022-03-27 | Blackford | Indiana | 18009 | 3123 | 69 |
2344019 | 2344019 | 2022-03-26 | Blackford | Indiana | 18009 | 3123 | 69 |
2340766 | 2340766 | 2022-03-25 | Blackford | Indiana | 18009 | 3123 | 69 |
2337513 | 2337513 | 2022-03-24 | Blackford | Indiana | 18009 | 3123 | 69 |
2334259 | 2334259 | 2022-03-23 | Blackford | Indiana | 18009 | 3123 | 69 |
2331005 | 2331005 | 2022-03-22 | Blackford | Indiana | 18009 | 3123 | 69 |
2327753 | 2327753 | 2022-03-21 | Blackford | Indiana | 18009 | 3122 | 69 |
2324500 | 2324500 | 2022-03-20 | Blackford | Indiana | 18009 | 3121 | 69 |
2321246 | 2321246 | 2022-03-19 | Blackford | Indiana | 18009 | 3121 | 69 |
2317992 | 2317992 | 2022-03-18 | Blackford | Indiana | 18009 | 3121 | 69 |
2314739 | 2314739 | 2022-03-17 | Blackford | Indiana | 18009 | 3121 | 69 |
2311486 | 2311486 | 2022-03-16 | Blackford | Indiana | 18009 | 3121 | 69 |
2308233 | 2308233 | 2022-03-15 | Blackford | Indiana | 18009 | 3120 | 69 |
2304982 | 2304982 | 2022-03-14 | Blackford | Indiana | 18009 | 3120 | 69 |
2301730 | 2301730 | 2022-03-13 | Blackford | Indiana | 18009 | 3120 | 69 |
2298478 | 2298478 | 2022-03-12 | Blackford | Indiana | 18009 | 3120 | 69 |
2295226 | 2295226 | 2022-03-11 | Blackford | Indiana | 18009 | 3120 | 69 |
2291974 | 2291974 | 2022-03-10 | Blackford | Indiana | 18009 | 3120 | 69 |
2288722 | 2288722 | 2022-03-09 | Blackford | Indiana | 18009 | 3120 | 69 |
2285471 | 2285471 | 2022-03-08 | Blackford | Indiana | 18009 | 3118 | 69 |
2282219 | 2282219 | 2022-03-07 | Blackford | Indiana | 18009 | 3118 | 69 |
2278966 | 2278966 | 2022-03-06 | Blackford | Indiana | 18009 | 3116 | 69 |
2275713 | 2275713 | 2022-03-05 | Blackford | Indiana | 18009 | 3116 | 69 |
2272460 | 2272460 | 2022-03-04 | Blackford | Indiana | 18009 | 3116 | 69 |
2269208 | 2269208 | 2022-03-03 | Blackford | Indiana | 18009 | 3114 | 69 |
2265955 | 2265955 | 2022-03-02 | Blackford | Indiana | 18009 | 3113 | 69 |
2262704 | 2262704 | 2022-03-01 | Blackford | Indiana | 18009 | 3109 | 68 |
2259453 | 2259453 | 2022-02-28 | Blackford | Indiana | 18009 | 3106 | 68 |
2256202 | 2256202 | 2022-02-27 | Blackford | Indiana | 18009 | 3102 | 68 |
2252951 | 2252951 | 2022-02-26 | Blackford | Indiana | 18009 | 3102 | 68 |
2249700 | 2249700 | 2022-02-25 | Blackford | Indiana | 18009 | 3102 | 68 |
2246449 | 2246449 | 2022-02-24 | Blackford | Indiana | 18009 | 3098 | 68 |
2243198 | 2243198 | 2022-02-23 | Blackford | Indiana | 18009 | 3095 | 68 |
2239947 | 2239947 | 2022-02-22 | Blackford | Indiana | 18009 | 3088 | 68 |
2236696 | 2236696 | 2022-02-21 | Blackford | Indiana | 18009 | 3087 | 68 |
2233445 | 2233445 | 2022-02-20 | Blackford | Indiana | 18009 | 3084 | 68 |
2230194 | 2230194 | 2022-02-19 | Blackford | Indiana | 18009 | 3084 | 68 |
2226943 | 2226943 | 2022-02-18 | Blackford | Indiana | 18009 | 3084 | 68 |
2223692 | 2223692 | 2022-02-17 | Blackford | Indiana | 18009 | 3084 | 66 |
2220441 | 2220441 | 2022-02-16 | Blackford | Indiana | 18009 | 3082 | 66 |
2217190 | 2217190 | 2022-02-15 | Blackford | Indiana | 18009 | 3078 | 66 |
2213939 | 2213939 | 2022-02-14 | Blackford | Indiana | 18009 | 3071 | 66 |
2210687 | 2210687 | 2022-02-13 | Blackford | Indiana | 18009 | 3064 | 66 |
2207434 | 2207434 | 2022-02-12 | Blackford | Indiana | 18009 | 3064 | 66 |
2204181 | 2204181 | 2022-02-11 | Blackford | Indiana | 18009 | 3064 | 66 |
2200928 | 2200928 | 2022-02-10 | Blackford | Indiana | 18009 | 3055 | 66 |
2197674 | 2197674 | 2022-02-09 | Blackford | Indiana | 18009 | 3044 | 66 |
2194420 | 2194420 | 2022-02-08 | Blackford | Indiana | 18009 | 3044 | 66 |
2191166 | 2191166 | 2022-02-07 | Blackford | Indiana | 18009 | 3040 | 66 |
2187913 | 2187913 | 2022-02-06 | Blackford | Indiana | 18009 | 3032 | 66 |
2184660 | 2184660 | 2022-02-05 | Blackford | Indiana | 18009 | 3032 | 66 |
2181408 | 2181408 | 2022-02-04 | Blackford | Indiana | 18009 | 3032 | 66 |
2178157 | 2178157 | 2022-02-03 | Blackford | Indiana | 18009 | 3024 | 66 |
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);