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

788 rows where county = "Franklin" and fips = 18047 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 18047 · 788 ✖

county 1

  • Franklin · 788 ✖
Link rowid date ▲ county state fips cases deaths
2500303 2500303 2022-05-13 Franklin Indiana 18047 4390 65
2497045 2497045 2022-05-12 Franklin Indiana 18047 4385 65
2493787 2493787 2022-05-11 Franklin Indiana 18047 4385 65
2490529 2490529 2022-05-10 Franklin Indiana 18047 4378 65
2487272 2487272 2022-05-09 Franklin Indiana 18047 4378 65
2484014 2484014 2022-05-08 Franklin Indiana 18047 4380 65
2480756 2480756 2022-05-07 Franklin Indiana 18047 4380 65
2477498 2477498 2022-05-06 Franklin Indiana 18047 4380 65
2474240 2474240 2022-05-05 Franklin Indiana 18047 4380 65
2470983 2470983 2022-05-04 Franklin Indiana 18047 4380 65
2467727 2467727 2022-05-03 Franklin Indiana 18047 4378 65
2464472 2464472 2022-05-02 Franklin Indiana 18047 4378 65
2461216 2461216 2022-05-01 Franklin Indiana 18047 4377 65
2457960 2457960 2022-04-30 Franklin Indiana 18047 4377 65
2454704 2454704 2022-04-29 Franklin Indiana 18047 4377 65
2451448 2451448 2022-04-28 Franklin Indiana 18047 4375 65
2448192 2448192 2022-04-27 Franklin Indiana 18047 4375 65
2444936 2444936 2022-04-26 Franklin Indiana 18047 4374 65
2441680 2441680 2022-04-25 Franklin Indiana 18047 4374 65
2438424 2438424 2022-04-24 Franklin Indiana 18047 4374 65
2435168 2435168 2022-04-23 Franklin Indiana 18047 4374 65
2431912 2431912 2022-04-22 Franklin Indiana 18047 4374 65
2428656 2428656 2022-04-21 Franklin Indiana 18047 4373 65
2425400 2425400 2022-04-20 Franklin Indiana 18047 4373 65
2422144 2422144 2022-04-19 Franklin Indiana 18047 4373 65
2418888 2418888 2022-04-18 Franklin Indiana 18047 4373 65
2415632 2415632 2022-04-17 Franklin Indiana 18047 4373 65
2412376 2412376 2022-04-16 Franklin Indiana 18047 4373 65
2409120 2409120 2022-04-15 Franklin Indiana 18047 4373 65
2405864 2405864 2022-04-14 Franklin Indiana 18047 4373 65
2402609 2402609 2022-04-13 Franklin Indiana 18047 4373 65
2399354 2399354 2022-04-12 Franklin Indiana 18047 4373 65
2396099 2396099 2022-04-11 Franklin Indiana 18047 4373 65
2392843 2392843 2022-04-10 Franklin Indiana 18047 4373 65
2389587 2389587 2022-04-09 Franklin Indiana 18047 4373 65
2386332 2386332 2022-04-08 Franklin Indiana 18047 4373 65
2383077 2383077 2022-04-07 Franklin Indiana 18047 4372 65
2379822 2379822 2022-04-06 Franklin Indiana 18047 4372 65
2376568 2376568 2022-04-05 Franklin Indiana 18047 4371 65
2373316 2373316 2022-04-04 Franklin Indiana 18047 4371 65
2370063 2370063 2022-04-03 Franklin Indiana 18047 4373 65
2366810 2366810 2022-04-02 Franklin Indiana 18047 4373 65
2363557 2363557 2022-04-01 Franklin Indiana 18047 4373 65
2360303 2360303 2022-03-31 Franklin Indiana 18047 4372 65
2357049 2357049 2022-03-30 Franklin Indiana 18047 4372 65
2353796 2353796 2022-03-29 Franklin Indiana 18047 4400 65
2350544 2350544 2022-03-28 Franklin Indiana 18047 4400 65
2347291 2347291 2022-03-27 Franklin Indiana 18047 4398 65
2344038 2344038 2022-03-26 Franklin Indiana 18047 4398 65
2340785 2340785 2022-03-25 Franklin Indiana 18047 4398 65
2337532 2337532 2022-03-24 Franklin Indiana 18047 4396 65
2334278 2334278 2022-03-23 Franklin Indiana 18047 4396 65
2331024 2331024 2022-03-22 Franklin Indiana 18047 4396 65
2327772 2327772 2022-03-21 Franklin Indiana 18047 4396 65
2324519 2324519 2022-03-20 Franklin Indiana 18047 4395 65
2321265 2321265 2022-03-19 Franklin Indiana 18047 4395 65
2318011 2318011 2022-03-18 Franklin Indiana 18047 4395 65
2314758 2314758 2022-03-17 Franklin Indiana 18047 4395 65
2311505 2311505 2022-03-16 Franklin Indiana 18047 4395 65
2308252 2308252 2022-03-15 Franklin Indiana 18047 4394 65
2305001 2305001 2022-03-14 Franklin Indiana 18047 4393 65
2301749 2301749 2022-03-13 Franklin Indiana 18047 4390 65
2298497 2298497 2022-03-12 Franklin Indiana 18047 4390 65
2295245 2295245 2022-03-11 Franklin Indiana 18047 4390 65
2291993 2291993 2022-03-10 Franklin Indiana 18047 4389 64
2288741 2288741 2022-03-09 Franklin Indiana 18047 4387 64
2285490 2285490 2022-03-08 Franklin Indiana 18047 4387 64
2282238 2282238 2022-03-07 Franklin Indiana 18047 4387 64
2278985 2278985 2022-03-06 Franklin Indiana 18047 4386 64
2275732 2275732 2022-03-05 Franklin Indiana 18047 4386 64
2272479 2272479 2022-03-04 Franklin Indiana 18047 4386 64
2269227 2269227 2022-03-03 Franklin Indiana 18047 4385 64
2265974 2265974 2022-03-02 Franklin Indiana 18047 4382 64
2262723 2262723 2022-03-01 Franklin Indiana 18047 4380 64
2259472 2259472 2022-02-28 Franklin Indiana 18047 4378 64
2256221 2256221 2022-02-27 Franklin Indiana 18047 4373 64
2252970 2252970 2022-02-26 Franklin Indiana 18047 4373 64
2249719 2249719 2022-02-25 Franklin Indiana 18047 4373 64
2246468 2246468 2022-02-24 Franklin Indiana 18047 4372 64
2243217 2243217 2022-02-23 Franklin Indiana 18047 4369 64
2239966 2239966 2022-02-22 Franklin Indiana 18047 4365 64
2236715 2236715 2022-02-21 Franklin Indiana 18047 4360 64
2233464 2233464 2022-02-20 Franklin Indiana 18047 4358 63
2230213 2230213 2022-02-19 Franklin Indiana 18047 4358 63
2226962 2226962 2022-02-18 Franklin Indiana 18047 4358 63
2223711 2223711 2022-02-17 Franklin Indiana 18047 4354 62
2220460 2220460 2022-02-16 Franklin Indiana 18047 4352 61
2217209 2217209 2022-02-15 Franklin Indiana 18047 4342 61
2213958 2213958 2022-02-14 Franklin Indiana 18047 4339 61
2210706 2210706 2022-02-13 Franklin Indiana 18047 4321 60
2207453 2207453 2022-02-12 Franklin Indiana 18047 4321 60
2204200 2204200 2022-02-11 Franklin Indiana 18047 4321 60
2200947 2200947 2022-02-10 Franklin Indiana 18047 4314 60
2197693 2197693 2022-02-09 Franklin Indiana 18047 4290 60
2194439 2194439 2022-02-08 Franklin Indiana 18047 4290 60
2191185 2191185 2022-02-07 Franklin Indiana 18047 4281 60
2187932 2187932 2022-02-06 Franklin Indiana 18047 4259 60
2184679 2184679 2022-02-05 Franklin Indiana 18047 4259 60
2181427 2181427 2022-02-04 Franklin Indiana 18047 4259 60
2178176 2178176 2022-02-03 Franklin Indiana 18047 4241 58

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