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

791 rows where county = "Tompkins" 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

county 1

  • Tompkins · 791 ✖
Link rowid date ▲ county state fips cases deaths
2501478 2501478 2022-05-13 Tompkins New York 36109 21144 85
2498220 2498220 2022-05-12 Tompkins New York 36109 21144 85
2494962 2494962 2022-05-11 Tompkins New York 36109 21071 85
2491704 2491704 2022-05-10 Tompkins New York 36109 20985 85
2488446 2488446 2022-05-09 Tompkins New York 36109 20943 85
2485189 2485189 2022-05-08 Tompkins New York 36109 20925 85
2481931 2481931 2022-05-07 Tompkins New York 36109 20861 85
2478673 2478673 2022-05-06 Tompkins New York 36109 20786 85
2475415 2475415 2022-05-05 Tompkins New York 36109 20677 85
2472158 2472158 2022-05-04 Tompkins New York 36109 20575 84
2468902 2468902 2022-05-03 Tompkins New York 36109 20467 84
2465646 2465646 2022-05-02 Tompkins New York 36109 20402 84
2462391 2462391 2022-05-01 Tompkins New York 36109 20388 84
2459135 2459135 2022-04-30 Tompkins New York 36109 20334 84
2455879 2455879 2022-04-29 Tompkins New York 36109 20263 84
2452623 2452623 2022-04-28 Tompkins New York 36109 20178 84
2449367 2449367 2022-04-27 Tompkins New York 36109 20087 84
2446110 2446110 2022-04-26 Tompkins New York 36109 19990 84
2442855 2442855 2022-04-25 Tompkins New York 36109 19933 84
2439599 2439599 2022-04-24 Tompkins New York 36109 19922 84
2436343 2436343 2022-04-23 Tompkins New York 36109 19855 84
2433087 2433087 2022-04-22 Tompkins New York 36109 19775 84
2429831 2429831 2022-04-21 Tompkins New York 36109 19700 84
2426575 2426575 2022-04-20 Tompkins New York 36109 19626 84
2423319 2423319 2022-04-19 Tompkins New York 36109 19539 84
2420062 2420062 2022-04-18 Tompkins New York 36109 19500 84
2416807 2416807 2022-04-17 Tompkins New York 36109 19488 84
2413551 2413551 2022-04-16 Tompkins New York 36109 19447 84
2410295 2410295 2022-04-15 Tompkins New York 36109 19401 84
2407039 2407039 2022-04-14 Tompkins New York 36109 19343 84
2403783 2403783 2022-04-13 Tompkins New York 36109 19275 84
2400528 2400528 2022-04-12 Tompkins New York 36109 19181 84
2397273 2397273 2022-04-11 Tompkins New York 36109 19113 84
2394018 2394018 2022-04-10 Tompkins New York 36109 19101 84
2390762 2390762 2022-04-09 Tompkins New York 36109 19052 84
2387506 2387506 2022-04-08 Tompkins New York 36109 18992 84
2384251 2384251 2022-04-07 Tompkins New York 36109 18938 84
2380996 2380996 2022-04-06 Tompkins New York 36109 18887 84
2377741 2377741 2022-04-05 Tompkins New York 36109 18826 84
2374488 2374488 2022-04-04 Tompkins New York 36109 18783 84
2371236 2371236 2022-04-03 Tompkins New York 36109 18775 84
2367983 2367983 2022-04-02 Tompkins New York 36109 18733 84
2364730 2364730 2022-04-01 Tompkins New York 36109 18679 84
2361476 2361476 2022-03-31 Tompkins New York 36109 18601 84
2358222 2358222 2022-03-30 Tompkins New York 36109 18529 83
2354968 2354968 2022-03-29 Tompkins New York 36109 18463 83
2351715 2351715 2022-03-28 Tompkins New York 36109 18423 83
2348463 2348463 2022-03-27 Tompkins New York 36109 18417 83
2345210 2345210 2022-03-26 Tompkins New York 36109 18342 83
2341957 2341957 2022-03-25 Tompkins New York 36109 18272 83
2338704 2338704 2022-03-24 Tompkins New York 36109 18125 83
2335450 2335450 2022-03-23 Tompkins New York 36109 18022 83
2332196 2332196 2022-03-22 Tompkins New York 36109 17966 83
2328943 2328943 2022-03-21 Tompkins New York 36109 17943 83
2325691 2325691 2022-03-20 Tompkins New York 36109 17939 83
2322438 2322438 2022-03-19 Tompkins New York 36109 17923 83
2319184 2319184 2022-03-18 Tompkins New York 36109 17883 83
2315930 2315930 2022-03-17 Tompkins New York 36109 17853 82
2312677 2312677 2022-03-16 Tompkins New York 36109 17822 82
2309424 2309424 2022-03-15 Tompkins New York 36109 17777 82
2306171 2306171 2022-03-14 Tompkins New York 36109 17756 82
2302920 2302920 2022-03-13 Tompkins New York 36109 17753 82
2299668 2299668 2022-03-12 Tompkins New York 36109 17730 82
2296416 2296416 2022-03-11 Tompkins New York 36109 17704 82
2293164 2293164 2022-03-10 Tompkins New York 36109 17664 82
2289912 2289912 2022-03-09 Tompkins New York 36109 17634 82
2286660 2286660 2022-03-08 Tompkins New York 36109 17596 82
2283408 2283408 2022-03-07 Tompkins New York 36109 17584 82
2280156 2280156 2022-03-06 Tompkins New York 36109 17580 82
2276903 2276903 2022-03-05 Tompkins New York 36109 17564 82
2273650 2273650 2022-03-04 Tompkins New York 36109 17472 82
2270397 2270397 2022-03-03 Tompkins New York 36109 17472 82
2267145 2267145 2022-03-02 Tompkins New York 36109 17446 82
2263893 2263893 2022-03-01 Tompkins New York 36109 17418 82
2260642 2260642 2022-02-28 Tompkins New York 36109 17396 82
2257391 2257391 2022-02-27 Tompkins New York 36109 17395 82
2254140 2254140 2022-02-26 Tompkins New York 36109 17361 81
2250889 2250889 2022-02-25 Tompkins New York 36109 17323 81
2247638 2247638 2022-02-24 Tompkins New York 36109 17296 81
2244387 2244387 2022-02-23 Tompkins New York 36109 17279 81
2241136 2241136 2022-02-22 Tompkins New York 36109 17255 81
2237885 2237885 2022-02-21 Tompkins New York 36109 17236 81
2234634 2234634 2022-02-20 Tompkins New York 36109 17235 81
2231383 2231383 2022-02-19 Tompkins New York 36109 17181 81
2228132 2228132 2022-02-18 Tompkins New York 36109 17156 81
2224881 2224881 2022-02-17 Tompkins New York 36109 17100 81
2221630 2221630 2022-02-16 Tompkins New York 36109 17062 80
2218379 2218379 2022-02-15 Tompkins New York 36109 17034 79
2215128 2215128 2022-02-14 Tompkins New York 36109 17011 79
2211877 2211877 2022-02-13 Tompkins New York 36109 17004 79
2208624 2208624 2022-02-12 Tompkins New York 36109 16958 79
2205371 2205371 2022-02-11 Tompkins New York 36109 16910 79
2202118 2202118 2022-02-10 Tompkins New York 36109 16870 79
2198864 2198864 2022-02-09 Tompkins New York 36109 16745 79
2195610 2195610 2022-02-08 Tompkins New York 36109 16743 79
2192356 2192356 2022-02-07 Tompkins New York 36109 16721 79
2189102 2189102 2022-02-06 Tompkins New York 36109 16709 77
2185849 2185849 2022-02-05 Tompkins New York 36109 16678 77
2182597 2182597 2022-02-04 Tompkins New York 36109 16631 77
2179345 2179345 2022-02-03 Tompkins New York 36109 16534 77

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