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

780 rows where county = "Franklin" and state = "New York" sorted by date descending

✎ View and edit SQL

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

state 1

  • New York · 780 ✖

fips 1

county 1

  • Franklin · 780 ✖
Link rowid date ▲ county state fips cases deaths
2501443 2501443 2022-05-13 Franklin New York 36033 10059 46
2498185 2498185 2022-05-12 Franklin New York 36033 10059 46
2494927 2494927 2022-05-11 Franklin New York 36033 10026 46
2491669 2491669 2022-05-10 Franklin New York 36033 10015 46
2488411 2488411 2022-05-09 Franklin New York 36033 10005 46
2485154 2485154 2022-05-08 Franklin New York 36033 9994 46
2481896 2481896 2022-05-07 Franklin New York 36033 9981 46
2478638 2478638 2022-05-06 Franklin New York 36033 9951 46
2475380 2475380 2022-05-05 Franklin New York 36033 9925 46
2472123 2472123 2022-05-04 Franklin New York 36033 9902 46
2468867 2468867 2022-05-03 Franklin New York 36033 9883 45
2465611 2465611 2022-05-02 Franklin New York 36033 9870 45
2462356 2462356 2022-05-01 Franklin New York 36033 9855 45
2459100 2459100 2022-04-30 Franklin New York 36033 9842 45
2455844 2455844 2022-04-29 Franklin New York 36033 9825 45
2452588 2452588 2022-04-28 Franklin New York 36033 9798 45
2449332 2449332 2022-04-27 Franklin New York 36033 9774 45
2446075 2446075 2022-04-26 Franklin New York 36033 9758 45
2442820 2442820 2022-04-25 Franklin New York 36033 9747 45
2439564 2439564 2022-04-24 Franklin New York 36033 9730 45
2436308 2436308 2022-04-23 Franklin New York 36033 9719 45
2433052 2433052 2022-04-22 Franklin New York 36033 9705 45
2429796 2429796 2022-04-21 Franklin New York 36033 9684 45
2426540 2426540 2022-04-20 Franklin New York 36033 9673 45
2423284 2423284 2022-04-19 Franklin New York 36033 9661 44
2420027 2420027 2022-04-18 Franklin New York 36033 9651 44
2416772 2416772 2022-04-17 Franklin New York 36033 9646 44
2413516 2413516 2022-04-16 Franklin New York 36033 9633 44
2410260 2410260 2022-04-15 Franklin New York 36033 9610 44
2407004 2407004 2022-04-14 Franklin New York 36033 9599 44
2403748 2403748 2022-04-13 Franklin New York 36033 9585 44
2400493 2400493 2022-04-12 Franklin New York 36033 9576 44
2397238 2397238 2022-04-11 Franklin New York 36033 9570 44
2393983 2393983 2022-04-10 Franklin New York 36033 9568 44
2390727 2390727 2022-04-09 Franklin New York 36033 9553 44
2387471 2387471 2022-04-08 Franklin New York 36033 9546 44
2384216 2384216 2022-04-07 Franklin New York 36033 9539 44
2380961 2380961 2022-04-06 Franklin New York 36033 9520 44
2377706 2377706 2022-04-05 Franklin New York 36033 9515 44
2374453 2374453 2022-04-04 Franklin New York 36033 9503 44
2371201 2371201 2022-04-03 Franklin New York 36033 9495 44
2367948 2367948 2022-04-02 Franklin New York 36033 9485 44
2364695 2364695 2022-04-01 Franklin New York 36033 9478 44
2361441 2361441 2022-03-31 Franklin New York 36033 9461 44
2358187 2358187 2022-03-30 Franklin New York 36033 9454 44
2354933 2354933 2022-03-29 Franklin New York 36033 9443 44
2351680 2351680 2022-03-28 Franklin New York 36033 9441 44
2348428 2348428 2022-03-27 Franklin New York 36033 9432 44
2345175 2345175 2022-03-26 Franklin New York 36033 9420 44
2341922 2341922 2022-03-25 Franklin New York 36033 9409 44
2338669 2338669 2022-03-24 Franklin New York 36033 9400 44
2335415 2335415 2022-03-23 Franklin New York 36033 9386 44
2332161 2332161 2022-03-22 Franklin New York 36033 9359 44
2328908 2328908 2022-03-21 Franklin New York 36033 9348 44
2325656 2325656 2022-03-20 Franklin New York 36033 9343 44
2322403 2322403 2022-03-19 Franklin New York 36033 9332 44
2319149 2319149 2022-03-18 Franklin New York 36033 9300 44
2315895 2315895 2022-03-17 Franklin New York 36033 9284 44
2312642 2312642 2022-03-16 Franklin New York 36033 9261 44
2309389 2309389 2022-03-15 Franklin New York 36033 9251 44
2306136 2306136 2022-03-14 Franklin New York 36033 9248 44
2302885 2302885 2022-03-13 Franklin New York 36033 9238 44
2299633 2299633 2022-03-12 Franklin New York 36033 9228 44
2296381 2296381 2022-03-11 Franklin New York 36033 9211 44
2293129 2293129 2022-03-10 Franklin New York 36033 9192 44
2289877 2289877 2022-03-09 Franklin New York 36033 9181 44
2286625 2286625 2022-03-08 Franklin New York 36033 9175 44
2283373 2283373 2022-03-07 Franklin New York 36033 9169 44
2280121 2280121 2022-03-06 Franklin New York 36033 9155 44
2276868 2276868 2022-03-05 Franklin New York 36033 9139 44
2273615 2273615 2022-03-04 Franklin New York 36033 9091 44
2270362 2270362 2022-03-03 Franklin New York 36033 9091 44
2267110 2267110 2022-03-02 Franklin New York 36033 9071 44
2263858 2263858 2022-03-01 Franklin New York 36033 9064 44
2260607 2260607 2022-02-28 Franklin New York 36033 9053 44
2257356 2257356 2022-02-27 Franklin New York 36033 9043 44
2254105 2254105 2022-02-26 Franklin New York 36033 9030 44
2250854 2250854 2022-02-25 Franklin New York 36033 9008 44
2247603 2247603 2022-02-24 Franklin New York 36033 8994 44
2244352 2244352 2022-02-23 Franklin New York 36033 8981 44
2241101 2241101 2022-02-22 Franklin New York 36033 8972 44
2237850 2237850 2022-02-21 Franklin New York 36033 8965 42
2234599 2234599 2022-02-20 Franklin New York 36033 8955 41
2231348 2231348 2022-02-19 Franklin New York 36033 8936 41
2228097 2228097 2022-02-18 Franklin New York 36033 8914 41
2224846 2224846 2022-02-17 Franklin New York 36033 8892 41
2221595 2221595 2022-02-16 Franklin New York 36033 8863 40
2218344 2218344 2022-02-15 Franklin New York 36033 8843 40
2215093 2215093 2022-02-14 Franklin New York 36033 8823 40
2211842 2211842 2022-02-13 Franklin New York 36033 8803 40
2208589 2208589 2022-02-12 Franklin New York 36033 8780 40
2205336 2205336 2022-02-11 Franklin New York 36033 8756 40
2202083 2202083 2022-02-10 Franklin New York 36033 8726 40
2198829 2198829 2022-02-09 Franklin New York 36033 8692 40
2195575 2195575 2022-02-08 Franklin New York 36033 8666 40
2192321 2192321 2022-02-07 Franklin New York 36033 8650 40
2189067 2189067 2022-02-06 Franklin New York 36033 8628 40
2185814 2185814 2022-02-05 Franklin New York 36033 8593 40
2182562 2182562 2022-02-04 Franklin New York 36033 8571 40
2179310 2179310 2022-02-03 Franklin New York 36033 8519 40

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