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

790 rows where county = "Greene" and fips = 36039 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

  • 36039 · 790 ✖

county 1

  • Greene · 790 ✖
Link rowid date ▲ county state fips cases deaths
2501446 2501446 2022-05-13 Greene New York 36039 9055 130
2498188 2498188 2022-05-12 Greene New York 36039 9055 129
2494930 2494930 2022-05-11 Greene New York 36039 9044 129
2491672 2491672 2022-05-10 Greene New York 36039 9025 129
2488414 2488414 2022-05-09 Greene New York 36039 9017 129
2485157 2485157 2022-05-08 Greene New York 36039 9012 129
2481899 2481899 2022-05-07 Greene New York 36039 9002 129
2478641 2478641 2022-05-06 Greene New York 36039 8990 129
2475383 2475383 2022-05-05 Greene New York 36039 8961 129
2472126 2472126 2022-05-04 Greene New York 36039 8943 129
2468870 2468870 2022-05-03 Greene New York 36039 8921 129
2465614 2465614 2022-05-02 Greene New York 36039 8914 129
2462359 2462359 2022-05-01 Greene New York 36039 8910 129
2459103 2459103 2022-04-30 Greene New York 36039 8898 129
2455847 2455847 2022-04-29 Greene New York 36039 8886 126
2452591 2452591 2022-04-28 Greene New York 36039 8869 125
2449335 2449335 2022-04-27 Greene New York 36039 8853 125
2446078 2446078 2022-04-26 Greene New York 36039 8826 125
2442823 2442823 2022-04-25 Greene New York 36039 8820 125
2439567 2439567 2022-04-24 Greene New York 36039 8812 125
2436311 2436311 2022-04-23 Greene New York 36039 8801 125
2433055 2433055 2022-04-22 Greene New York 36039 8788 125
2429799 2429799 2022-04-21 Greene New York 36039 8781 125
2426543 2426543 2022-04-20 Greene New York 36039 8764 125
2423287 2423287 2022-04-19 Greene New York 36039 8745 125
2420030 2420030 2022-04-18 Greene New York 36039 8741 125
2416775 2416775 2022-04-17 Greene New York 36039 8735 125
2413519 2413519 2022-04-16 Greene New York 36039 8727 125
2410263 2410263 2022-04-15 Greene New York 36039 8720 125
2407007 2407007 2022-04-14 Greene New York 36039 8708 125
2403751 2403751 2022-04-13 Greene New York 36039 8696 125
2400496 2400496 2022-04-12 Greene New York 36039 8682 125
2397241 2397241 2022-04-11 Greene New York 36039 8675 125
2393986 2393986 2022-04-10 Greene New York 36039 8674 125
2390730 2390730 2022-04-09 Greene New York 36039 8668 125
2387474 2387474 2022-04-08 Greene New York 36039 8660 125
2384219 2384219 2022-04-07 Greene New York 36039 8651 125
2380964 2380964 2022-04-06 Greene New York 36039 8644 125
2377709 2377709 2022-04-05 Greene New York 36039 8634 125
2374456 2374456 2022-04-04 Greene New York 36039 8633 125
2371204 2371204 2022-04-03 Greene New York 36039 8630 125
2367951 2367951 2022-04-02 Greene New York 36039 8623 125
2364698 2364698 2022-04-01 Greene New York 36039 8613 125
2361444 2361444 2022-03-31 Greene New York 36039 8601 125
2358190 2358190 2022-03-30 Greene New York 36039 8597 124
2354936 2354936 2022-03-29 Greene New York 36039 8594 124
2351683 2351683 2022-03-28 Greene New York 36039 8593 124
2348431 2348431 2022-03-27 Greene New York 36039 8592 124
2345178 2345178 2022-03-26 Greene New York 36039 8586 124
2341925 2341925 2022-03-25 Greene New York 36039 8580 123
2338672 2338672 2022-03-24 Greene New York 36039 8558 123
2335418 2335418 2022-03-23 Greene New York 36039 8553 123
2332164 2332164 2022-03-22 Greene New York 36039 8520 123
2328911 2328911 2022-03-21 Greene New York 36039 8518 123
2325659 2325659 2022-03-20 Greene New York 36039 8517 123
2322406 2322406 2022-03-19 Greene New York 36039 8512 123
2319152 2319152 2022-03-18 Greene New York 36039 8506 123
2315898 2315898 2022-03-17 Greene New York 36039 8501 123
2312645 2312645 2022-03-16 Greene New York 36039 8498 123
2309392 2309392 2022-03-15 Greene New York 36039 8487 123
2306139 2306139 2022-03-14 Greene New York 36039 8483 123
2302888 2302888 2022-03-13 Greene New York 36039 8481 123
2299636 2299636 2022-03-12 Greene New York 36039 8478 123
2296384 2296384 2022-03-11 Greene New York 36039 8478 123
2293132 2293132 2022-03-10 Greene New York 36039 8473 123
2289880 2289880 2022-03-09 Greene New York 36039 8466 123
2286628 2286628 2022-03-08 Greene New York 36039 8463 123
2283376 2283376 2022-03-07 Greene New York 36039 8462 122
2280124 2280124 2022-03-06 Greene New York 36039 8460 122
2276871 2276871 2022-03-05 Greene New York 36039 8459 122
2273618 2273618 2022-03-04 Greene New York 36039 8453 121
2270365 2270365 2022-03-03 Greene New York 36039 8453 120
2267113 2267113 2022-03-02 Greene New York 36039 8449 120
2263861 2263861 2022-03-01 Greene New York 36039 8436 120
2260610 2260610 2022-02-28 Greene New York 36039 8433 120
2257359 2257359 2022-02-27 Greene New York 36039 8430 119
2254108 2254108 2022-02-26 Greene New York 36039 8426 119
2250857 2250857 2022-02-25 Greene New York 36039 8415 119
2247606 2247606 2022-02-24 Greene New York 36039 8411 119
2244355 2244355 2022-02-23 Greene New York 36039 8404 119
2241104 2241104 2022-02-22 Greene New York 36039 8400 119
2237853 2237853 2022-02-21 Greene New York 36039 8392 118
2234602 2234602 2022-02-20 Greene New York 36039 8390 118
2231351 2231351 2022-02-19 Greene New York 36039 8381 118
2228100 2228100 2022-02-18 Greene New York 36039 8379 118
2224849 2224849 2022-02-17 Greene New York 36039 8370 117
2221598 2221598 2022-02-16 Greene New York 36039 8363 117
2218347 2218347 2022-02-15 Greene New York 36039 8354 117
2215096 2215096 2022-02-14 Greene New York 36039 8344 117
2211845 2211845 2022-02-13 Greene New York 36039 8338 117
2208592 2208592 2022-02-12 Greene New York 36039 8323 117
2205339 2205339 2022-02-11 Greene New York 36039 8315 117
2202086 2202086 2022-02-10 Greene New York 36039 8306 116
2198832 2198832 2022-02-09 Greene New York 36039 8287 115
2195578 2195578 2022-02-08 Greene New York 36039 8255 115
2192324 2192324 2022-02-07 Greene New York 36039 8252 115
2189070 2189070 2022-02-06 Greene New York 36039 8247 115
2185817 2185817 2022-02-05 Greene New York 36039 8232 115
2182565 2182565 2022-02-04 Greene New York 36039 8220 114
2179313 2179313 2022-02-03 Greene New York 36039 8195 113

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