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 = "Franklin" and state = "Maine" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Maine · 779 ✖

fips 1

county 1

  • Franklin · 779 ✖
Link rowid date ▲ county state fips cases deaths
2500767 2500767 2022-05-13 Franklin Maine 23007 6014 60
2497509 2497509 2022-05-12 Franklin Maine 23007 6007 60
2494251 2494251 2022-05-11 Franklin Maine 23007 5996 60
2490993 2490993 2022-05-10 Franklin Maine 23007 5985 59
2487736 2487736 2022-05-09 Franklin Maine 23007 5978 59
2484478 2484478 2022-05-08 Franklin Maine 23007 5974 59
2481220 2481220 2022-05-07 Franklin Maine 23007 5974 59
2477962 2477962 2022-05-06 Franklin Maine 23007 5950 59
2474704 2474704 2022-05-05 Franklin Maine 23007 5940 59
2471447 2471447 2022-05-04 Franklin Maine 23007 5931 59
2468191 2468191 2022-05-03 Franklin Maine 23007 5901 59
2464936 2464936 2022-05-02 Franklin Maine 23007 5872 59
2461680 2461680 2022-05-01 Franklin Maine 23007 5860 59
2458424 2458424 2022-04-30 Franklin Maine 23007 5860 59
2455168 2455168 2022-04-29 Franklin Maine 23007 5841 59
2451912 2451912 2022-04-28 Franklin Maine 23007 5832 59
2448656 2448656 2022-04-27 Franklin Maine 23007 5821 59
2445400 2445400 2022-04-26 Franklin Maine 23007 5807 59
2442144 2442144 2022-04-25 Franklin Maine 23007 5788 59
2438888 2438888 2022-04-24 Franklin Maine 23007 5788 59
2435632 2435632 2022-04-23 Franklin Maine 23007 5788 59
2432376 2432376 2022-04-22 Franklin Maine 23007 5776 59
2429120 2429120 2022-04-21 Franklin Maine 23007 5770 59
2425864 2425864 2022-04-20 Franklin Maine 23007 5763 59
2422608 2422608 2022-04-19 Franklin Maine 23007 5737 59
2419352 2419352 2022-04-18 Franklin Maine 23007 5737 59
2416096 2416096 2022-04-17 Franklin Maine 23007 5737 59
2412840 2412840 2022-04-16 Franklin Maine 23007 5737 59
2409584 2409584 2022-04-15 Franklin Maine 23007 5718 59
2406328 2406328 2022-04-14 Franklin Maine 23007 5703 59
2403072 2403072 2022-04-13 Franklin Maine 23007 5699 59
2399818 2399818 2022-04-12 Franklin Maine 23007 5697 59
2396562 2396562 2022-04-11 Franklin Maine 23007 5684 57
2393307 2393307 2022-04-10 Franklin Maine 23007 5684 57
2390051 2390051 2022-04-09 Franklin Maine 23007 5684 57
2386795 2386795 2022-04-08 Franklin Maine 23007 5681 57
2383540 2383540 2022-04-07 Franklin Maine 23007 5676 57
2380285 2380285 2022-04-06 Franklin Maine 23007 5673 57
2377030 2377030 2022-04-05 Franklin Maine 23007 5671 57
2373778 2373778 2022-04-04 Franklin Maine 23007 5664 57
2370525 2370525 2022-04-03 Franklin Maine 23007 5664 57
2367272 2367272 2022-04-02 Franklin Maine 23007 5664 57
2364019 2364019 2022-04-01 Franklin Maine 23007 5657 57
2360765 2360765 2022-03-31 Franklin Maine 23007 5650 57
2357511 2357511 2022-03-30 Franklin Maine 23007 5649 57
2354258 2354258 2022-03-29 Franklin Maine 23007 5648 57
2351006 2351006 2022-03-28 Franklin Maine 23007 5637 57
2347753 2347753 2022-03-27 Franklin Maine 23007 5637 57
2344500 2344500 2022-03-26 Franklin Maine 23007 5637 57
2341247 2341247 2022-03-25 Franklin Maine 23007 5632 57
2337994 2337994 2022-03-24 Franklin Maine 23007 5630 57
2334740 2334740 2022-03-23 Franklin Maine 23007 5626 57
2331486 2331486 2022-03-22 Franklin Maine 23007 5619 57
2328234 2328234 2022-03-21 Franklin Maine 23007 5621 57
2324981 2324981 2022-03-20 Franklin Maine 23007 5621 57
2321727 2321727 2022-03-19 Franklin Maine 23007 5621 57
2318473 2318473 2022-03-18 Franklin Maine 23007 5621 57
2315220 2315220 2022-03-17 Franklin Maine 23007 5613 57
2311967 2311967 2022-03-16 Franklin Maine 23007 5614 57
2308714 2308714 2022-03-15 Franklin Maine 23007 5611 56
2305463 2305463 2022-03-14 Franklin Maine 23007 5602 56
2302211 2302211 2022-03-13 Franklin Maine 23007 5602 56
2298959 2298959 2022-03-12 Franklin Maine 23007 5602 56
2295707 2295707 2022-03-11 Franklin Maine 23007 5597 56
2292455 2292455 2022-03-10 Franklin Maine 23007 5585 56
2289203 2289203 2022-03-09 Franklin Maine 23007 5581 56
2285952 2285952 2022-03-08 Franklin Maine 23007 5581 56
2282700 2282700 2022-03-07 Franklin Maine 23007 5572 56
2279447 2279447 2022-03-06 Franklin Maine 23007 5572 56
2276194 2276194 2022-03-05 Franklin Maine 23007 5572 56
2272941 2272941 2022-03-04 Franklin Maine 23007 5569 56
2269689 2269689 2022-03-03 Franklin Maine 23007 5541 56
2266436 2266436 2022-03-02 Franklin Maine 23007 5535 56
2263185 2263185 2022-03-01 Franklin Maine 23007 5510 56
2259934 2259934 2022-02-28 Franklin Maine 23007 5504 56
2256683 2256683 2022-02-27 Franklin Maine 23007 5504 56
2253432 2253432 2022-02-26 Franklin Maine 23007 5503 56
2250181 2250181 2022-02-25 Franklin Maine 23007 5493 55
2246930 2246930 2022-02-24 Franklin Maine 23007 5486 55
2243679 2243679 2022-02-23 Franklin Maine 23007 5477 52
2240428 2240428 2022-02-22 Franklin Maine 23007 5424 52
2237177 2237177 2022-02-21 Franklin Maine 23007 5403 52
2233926 2233926 2022-02-20 Franklin Maine 23007 5374 52
2230675 2230675 2022-02-19 Franklin Maine 23007 5233 52
2227424 2227424 2022-02-18 Franklin Maine 23007 5119 51
2224173 2224173 2022-02-17 Franklin Maine 23007 5012 50
2220922 2220922 2022-02-16 Franklin Maine 23007 4895 50
2217671 2217671 2022-02-15 Franklin Maine 23007 4810 50
2214420 2214420 2022-02-14 Franklin Maine 23007 4601 50
2211168 2211168 2022-02-13 Franklin Maine 23007 4601 50
2207915 2207915 2022-02-12 Franklin Maine 23007 4601 50
2204662 2204662 2022-02-11 Franklin Maine 23007 4540 50
2201409 2201409 2022-02-10 Franklin Maine 23007 4516 50
2198155 2198155 2022-02-09 Franklin Maine 23007 4513 50
2194901 2194901 2022-02-08 Franklin Maine 23007 4472 50
2191647 2191647 2022-02-07 Franklin Maine 23007 4451 49
2188394 2188394 2022-02-06 Franklin Maine 23007 4451 49
2185141 2185141 2022-02-05 Franklin Maine 23007 4451 49
2181889 2181889 2022-02-04 Franklin Maine 23007 4433 49
2178638 2178638 2022-02-03 Franklin Maine 23007 4416 49

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