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

781 rows where county = "Orleans" and fips = 36073 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

  • 36073 · 781 ✖

county 1

  • Orleans · 781 ✖
Link rowid date ▲ county state fips cases deaths
2501462 2501462 2022-05-13 Orleans New York 36073 9116 117
2498204 2498204 2022-05-12 Orleans New York 36073 9116 116
2494946 2494946 2022-05-11 Orleans New York 36073 9084 116
2491688 2491688 2022-05-10 Orleans New York 36073 9068 116
2488430 2488430 2022-05-09 Orleans New York 36073 9048 115
2485173 2485173 2022-05-08 Orleans New York 36073 9038 115
2481915 2481915 2022-05-07 Orleans New York 36073 9022 115
2478657 2478657 2022-05-06 Orleans New York 36073 9004 114
2475399 2475399 2022-05-05 Orleans New York 36073 8985 114
2472142 2472142 2022-05-04 Orleans New York 36073 8958 114
2468886 2468886 2022-05-03 Orleans New York 36073 8942 114
2465630 2465630 2022-05-02 Orleans New York 36073 8922 113
2462375 2462375 2022-05-01 Orleans New York 36073 8913 113
2459119 2459119 2022-04-30 Orleans New York 36073 8906 113
2455863 2455863 2022-04-29 Orleans New York 36073 8882 113
2452607 2452607 2022-04-28 Orleans New York 36073 8855 113
2449351 2449351 2022-04-27 Orleans New York 36073 8834 113
2446094 2446094 2022-04-26 Orleans New York 36073 8818 113
2442839 2442839 2022-04-25 Orleans New York 36073 8804 113
2439583 2439583 2022-04-24 Orleans New York 36073 8790 113
2436327 2436327 2022-04-23 Orleans New York 36073 8771 113
2433071 2433071 2022-04-22 Orleans New York 36073 8758 113
2429815 2429815 2022-04-21 Orleans New York 36073 8745 113
2426559 2426559 2022-04-20 Orleans New York 36073 8733 113
2423303 2423303 2022-04-19 Orleans New York 36073 8719 113
2420046 2420046 2022-04-18 Orleans New York 36073 8702 113
2416791 2416791 2022-04-17 Orleans New York 36073 8696 113
2413535 2413535 2022-04-16 Orleans New York 36073 8691 113
2410279 2410279 2022-04-15 Orleans New York 36073 8676 113
2407023 2407023 2022-04-14 Orleans New York 36073 8671 113
2403767 2403767 2022-04-13 Orleans New York 36073 8651 113
2400512 2400512 2022-04-12 Orleans New York 36073 8649 113
2397257 2397257 2022-04-11 Orleans New York 36073 8642 113
2394002 2394002 2022-04-10 Orleans New York 36073 8636 113
2390746 2390746 2022-04-09 Orleans New York 36073 8633 113
2387490 2387490 2022-04-08 Orleans New York 36073 8624 113
2384235 2384235 2022-04-07 Orleans New York 36073 8617 113
2380980 2380980 2022-04-06 Orleans New York 36073 8615 113
2377725 2377725 2022-04-05 Orleans New York 36073 8609 113
2374472 2374472 2022-04-04 Orleans New York 36073 8606 113
2371220 2371220 2022-04-03 Orleans New York 36073 8603 113
2367967 2367967 2022-04-02 Orleans New York 36073 8598 113
2364714 2364714 2022-04-01 Orleans New York 36073 8595 113
2361460 2361460 2022-03-31 Orleans New York 36073 8586 113
2358206 2358206 2022-03-30 Orleans New York 36073 8581 113
2354952 2354952 2022-03-29 Orleans New York 36073 8578 113
2351699 2351699 2022-03-28 Orleans New York 36073 8575 113
2348447 2348447 2022-03-27 Orleans New York 36073 8573 113
2345194 2345194 2022-03-26 Orleans New York 36073 8572 113
2341941 2341941 2022-03-25 Orleans New York 36073 8570 113
2338688 2338688 2022-03-24 Orleans New York 36073 8566 113
2335434 2335434 2022-03-23 Orleans New York 36073 8564 113
2332180 2332180 2022-03-22 Orleans New York 36073 8558 113
2328927 2328927 2022-03-21 Orleans New York 36073 8555 113
2325675 2325675 2022-03-20 Orleans New York 36073 8554 113
2322422 2322422 2022-03-19 Orleans New York 36073 8553 113
2319168 2319168 2022-03-18 Orleans New York 36073 8551 113
2315914 2315914 2022-03-17 Orleans New York 36073 8550 113
2312661 2312661 2022-03-16 Orleans New York 36073 8546 113
2309408 2309408 2022-03-15 Orleans New York 36073 8546 113
2306155 2306155 2022-03-14 Orleans New York 36073 8546 113
2302904 2302904 2022-03-13 Orleans New York 36073 8544 113
2299652 2299652 2022-03-12 Orleans New York 36073 8543 113
2296400 2296400 2022-03-11 Orleans New York 36073 8542 113
2293148 2293148 2022-03-10 Orleans New York 36073 8540 112
2289896 2289896 2022-03-09 Orleans New York 36073 8539 112
2286644 2286644 2022-03-08 Orleans New York 36073 8535 112
2283392 2283392 2022-03-07 Orleans New York 36073 8534 112
2280140 2280140 2022-03-06 Orleans New York 36073 8534 112
2276887 2276887 2022-03-05 Orleans New York 36073 8533 112
2273634 2273634 2022-03-04 Orleans New York 36073 8531 112
2270381 2270381 2022-03-03 Orleans New York 36073 8531 112
2267129 2267129 2022-03-02 Orleans New York 36073 8528 112
2263877 2263877 2022-03-01 Orleans New York 36073 8527 112
2260626 2260626 2022-02-28 Orleans New York 36073 8526 112
2257375 2257375 2022-02-27 Orleans New York 36073 8524 111
2254124 2254124 2022-02-26 Orleans New York 36073 8521 111
2250873 2250873 2022-02-25 Orleans New York 36073 8514 111
2247622 2247622 2022-02-24 Orleans New York 36073 8511 111
2244371 2244371 2022-02-23 Orleans New York 36073 8511 111
2241120 2241120 2022-02-22 Orleans New York 36073 8509 111
2237869 2237869 2022-02-21 Orleans New York 36073 8507 111
2234618 2234618 2022-02-20 Orleans New York 36073 8505 111
2231367 2231367 2022-02-19 Orleans New York 36073 8502 111
2228116 2228116 2022-02-18 Orleans New York 36073 8499 111
2224865 2224865 2022-02-17 Orleans New York 36073 8494 111
2221614 2221614 2022-02-16 Orleans New York 36073 8481 111
2218363 2218363 2022-02-15 Orleans New York 36073 8476 110
2215112 2215112 2022-02-14 Orleans New York 36073 8473 110
2211861 2211861 2022-02-13 Orleans New York 36073 8473 110
2208608 2208608 2022-02-12 Orleans New York 36073 8463 110
2205355 2205355 2022-02-11 Orleans New York 36073 8457 110
2202102 2202102 2022-02-10 Orleans New York 36073 8447 109
2198848 2198848 2022-02-09 Orleans New York 36073 8422 109
2195594 2195594 2022-02-08 Orleans New York 36073 8401 109
2192340 2192340 2022-02-07 Orleans New York 36073 8388 108
2189086 2189086 2022-02-06 Orleans New York 36073 8381 108
2185833 2185833 2022-02-05 Orleans New York 36073 8369 108
2182581 2182581 2022-02-04 Orleans New York 36073 8352 108
2179329 2179329 2022-02-03 Orleans New York 36073 8334 108

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