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

2,357 rows where county = "Orleans" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 3

fips 3

county 1

  • Orleans · 2,357 ✖
Link rowid date ▲ county state fips cases deaths
2500734 2500734 2022-05-13 Orleans Louisiana 22071 90328 1109
2501462 2501462 2022-05-13 Orleans New York 36073 9116 117
2502501 2502501 2022-05-13 Orleans Vermont 50019 6610 38
2497476 2497476 2022-05-12 Orleans Louisiana 22071 90134 1109
2498204 2498204 2022-05-12 Orleans New York 36073 9116 116
2499243 2499243 2022-05-12 Orleans Vermont 50019 6599 38
2494218 2494218 2022-05-11 Orleans Louisiana 22071 89868 1108
2494946 2494946 2022-05-11 Orleans New York 36073 9084 116
2495985 2495985 2022-05-11 Orleans Vermont 50019 6566 38
2490960 2490960 2022-05-10 Orleans Louisiana 22071 89671 1108
2491688 2491688 2022-05-10 Orleans New York 36073 9068 116
2492727 2492727 2022-05-10 Orleans Vermont 50019 6559 38
2487703 2487703 2022-05-09 Orleans Louisiana 22071 89563 1108
2488430 2488430 2022-05-09 Orleans New York 36073 9048 115
2489469 2489469 2022-05-09 Orleans Vermont 50019 6556 38
2484445 2484445 2022-05-08 Orleans Louisiana 22071 89322 1108
2485173 2485173 2022-05-08 Orleans New York 36073 9038 115
2486211 2486211 2022-05-08 Orleans Vermont 50019 6533 38
2481187 2481187 2022-05-07 Orleans Louisiana 22071 89322 1108
2481915 2481915 2022-05-07 Orleans New York 36073 9022 115
2482953 2482953 2022-05-07 Orleans Vermont 50019 6533 38
2477929 2477929 2022-05-06 Orleans Louisiana 22071 89322 1108
2478657 2478657 2022-05-06 Orleans New York 36073 9004 114
2479695 2479695 2022-05-06 Orleans Vermont 50019 6533 38
2474671 2474671 2022-05-05 Orleans Louisiana 22071 89172 1108
2475399 2475399 2022-05-05 Orleans New York 36073 8985 114
2476437 2476437 2022-05-05 Orleans Vermont 50019 6525 38
2471414 2471414 2022-05-04 Orleans Louisiana 22071 89046 1109
2472142 2472142 2022-05-04 Orleans New York 36073 8958 114
2473180 2473180 2022-05-04 Orleans Vermont 50019 6512 38
2468158 2468158 2022-05-03 Orleans Louisiana 22071 88929 1109
2468886 2468886 2022-05-03 Orleans New York 36073 8942 114
2469924 2469924 2022-05-03 Orleans Vermont 50019 6499 38
2464903 2464903 2022-05-02 Orleans Louisiana 22071 88845 1109
2465630 2465630 2022-05-02 Orleans New York 36073 8922 113
2466668 2466668 2022-05-02 Orleans Vermont 50019 6494 38
2461647 2461647 2022-05-01 Orleans Louisiana 22071 88690 1107
2462375 2462375 2022-05-01 Orleans New York 36073 8913 113
2463413 2463413 2022-05-01 Orleans Vermont 50019 6477 38
2458391 2458391 2022-04-30 Orleans Louisiana 22071 88690 1107
2459119 2459119 2022-04-30 Orleans New York 36073 8906 113
2460157 2460157 2022-04-30 Orleans Vermont 50019 6477 38
2455135 2455135 2022-04-29 Orleans Louisiana 22071 88690 1107
2455863 2455863 2022-04-29 Orleans New York 36073 8882 113
2456901 2456901 2022-04-29 Orleans Vermont 50019 6477 38
2451879 2451879 2022-04-28 Orleans Louisiana 22071 88568 1107
2452607 2452607 2022-04-28 Orleans New York 36073 8855 113
2453645 2453645 2022-04-28 Orleans Vermont 50019 6471 38
2448623 2448623 2022-04-27 Orleans Louisiana 22071 88519 1107
2449351 2449351 2022-04-27 Orleans New York 36073 8834 113
2450389 2450389 2022-04-27 Orleans Vermont 50019 6422 37
2445367 2445367 2022-04-26 Orleans Louisiana 22071 88416 1107
2446094 2446094 2022-04-26 Orleans New York 36073 8818 113
2447132 2447132 2022-04-26 Orleans Vermont 50019 6422 37
2442111 2442111 2022-04-25 Orleans Louisiana 22071 88363 1107
2442839 2442839 2022-04-25 Orleans New York 36073 8804 113
2443877 2443877 2022-04-25 Orleans Vermont 50019 6422 37
2438855 2438855 2022-04-24 Orleans Louisiana 22071 88161 1107
2439583 2439583 2022-04-24 Orleans New York 36073 8790 113
2440621 2440621 2022-04-24 Orleans Vermont 50019 6400 37
2435599 2435599 2022-04-23 Orleans Louisiana 22071 88161 1107
2436327 2436327 2022-04-23 Orleans New York 36073 8771 113
2437365 2437365 2022-04-23 Orleans Vermont 50019 6400 37
2432343 2432343 2022-04-22 Orleans Louisiana 22071 88161 1107
2433071 2433071 2022-04-22 Orleans New York 36073 8758 113
2434109 2434109 2022-04-22 Orleans Vermont 50019 6400 37
2429087 2429087 2022-04-21 Orleans Louisiana 22071 88083 1107
2429815 2429815 2022-04-21 Orleans New York 36073 8745 113
2430853 2430853 2022-04-21 Orleans Vermont 50019 6386 37
2425831 2425831 2022-04-20 Orleans Louisiana 22071 88035 1108
2426559 2426559 2022-04-20 Orleans New York 36073 8733 113
2427597 2427597 2022-04-20 Orleans Vermont 50019 6372 37
2422575 2422575 2022-04-19 Orleans Louisiana 22071 87992 1108
2423303 2423303 2022-04-19 Orleans New York 36073 8719 113
2424341 2424341 2022-04-19 Orleans Vermont 50019 6361 37
2419319 2419319 2022-04-18 Orleans Louisiana 22071 87942 1108
2420046 2420046 2022-04-18 Orleans New York 36073 8702 113
2421085 2421085 2022-04-18 Orleans Vermont 50019 6354 37
2416063 2416063 2022-04-17 Orleans Louisiana 22071 87728 1108
2416791 2416791 2022-04-17 Orleans New York 36073 8696 113
2417829 2417829 2022-04-17 Orleans Vermont 50019 6328 37
2412807 2412807 2022-04-16 Orleans Louisiana 22071 87728 1108
2413535 2413535 2022-04-16 Orleans New York 36073 8691 113
2414573 2414573 2022-04-16 Orleans Vermont 50019 6328 37
2409551 2409551 2022-04-15 Orleans Louisiana 22071 87728 1108
2410279 2410279 2022-04-15 Orleans New York 36073 8676 113
2411317 2411317 2022-04-15 Orleans Vermont 50019 6328 37
2406295 2406295 2022-04-14 Orleans Louisiana 22071 87728 1108
2407023 2407023 2022-04-14 Orleans New York 36073 8671 113
2408061 2408061 2022-04-14 Orleans Vermont 50019 6316 37
2403039 2403039 2022-04-13 Orleans Louisiana 22071 87681 1108
2403767 2403767 2022-04-13 Orleans New York 36073 8651 113
2404805 2404805 2022-04-13 Orleans Vermont 50019 6294 37
2399785 2399785 2022-04-12 Orleans Louisiana 22071 87612 1108
2400512 2400512 2022-04-12 Orleans New York 36073 8649 113
2401550 2401550 2022-04-12 Orleans Vermont 50019 6287 37
2396529 2396529 2022-04-11 Orleans Louisiana 22071 87569 1108
2397257 2397257 2022-04-11 Orleans New York 36073 8642 113
2398295 2398295 2022-04-11 Orleans Vermont 50019 6284 37
2393274 2393274 2022-04-10 Orleans Louisiana 22071 87521 1108

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