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

6,253 rows where county = "Harrison" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 8

fips 8

county 1

  • Harrison · 6,253 ✖
Link rowid date ▲ county state fips cases deaths
2500310 2500310 2022-05-13 Harrison Indiana 18061 10889 138
2500415 2500415 2022-05-13 Harrison Iowa 19085 3437 95
2500627 2500627 2022-05-13 Harrison Kentucky 21097 6417 76
2501016 2501016 2022-05-13 Harrison Mississippi 28047 53859 665
2501116 2501116 2022-05-13 Harrison Missouri 29081 1876 33
2501677 2501677 2022-05-13 Harrison Ohio 39067 3263 74
2502308 2502308 2022-05-13 Harrison Texas 48203 13370 227
2502699 2502699 2022-05-13 Harrison West Virginia 54033 20062 253
2497052 2497052 2022-05-12 Harrison Indiana 18061 10880 138
2497157 2497157 2022-05-12 Harrison Iowa 19085 3437 95
2497369 2497369 2022-05-12 Harrison Kentucky 21097 6417 76
2497758 2497758 2022-05-12 Harrison Mississippi 28047 53859 665
2497858 2497858 2022-05-12 Harrison Missouri 29081 1869 33
2498419 2498419 2022-05-12 Harrison Ohio 39067 3263 74
2499050 2499050 2022-05-12 Harrison Texas 48203 13366 227
2499441 2499441 2022-05-12 Harrison West Virginia 54033 20039 253
2493794 2493794 2022-05-11 Harrison Indiana 18061 10880 138
2493899 2493899 2022-05-11 Harrison Iowa 19085 3437 95
2494111 2494111 2022-05-11 Harrison Kentucky 21097 6417 76
2494500 2494500 2022-05-11 Harrison Mississippi 28047 53859 665
2494600 2494600 2022-05-11 Harrison Missouri 29081 1869 33
2495161 2495161 2022-05-11 Harrison Ohio 39067 3252 74
2495792 2495792 2022-05-11 Harrison Texas 48203 13362 227
2496183 2496183 2022-05-11 Harrison West Virginia 54033 20012 253
2490536 2490536 2022-05-10 Harrison Indiana 18061 10865 138
2490641 2490641 2022-05-10 Harrison Iowa 19085 3435 95
2490853 2490853 2022-05-10 Harrison Kentucky 21097 6417 76
2491242 2491242 2022-05-10 Harrison Mississippi 28047 53859 665
2491342 2491342 2022-05-10 Harrison Missouri 29081 1869 33
2491903 2491903 2022-05-10 Harrison Ohio 39067 3252 74
2492534 2492534 2022-05-10 Harrison Texas 48203 13355 227
2492925 2492925 2022-05-10 Harrison West Virginia 54033 19980 253
2487279 2487279 2022-05-09 Harrison Indiana 18061 10865 138
2487384 2487384 2022-05-09 Harrison Iowa 19085 3435 95
2487596 2487596 2022-05-09 Harrison Kentucky 21097 6417 76
2487985 2487985 2022-05-09 Harrison Mississippi 28047 53859 665
2488084 2488084 2022-05-09 Harrison Missouri 29081 1869 33
2488645 2488645 2022-05-09 Harrison Ohio 39067 3252 74
2489276 2489276 2022-05-09 Harrison Texas 48203 13349 227
2489667 2489667 2022-05-09 Harrison West Virginia 54033 19980 253
2484021 2484021 2022-05-08 Harrison Indiana 18061 10851 138
2484126 2484126 2022-05-08 Harrison Iowa 19085 3435 95
2484338 2484338 2022-05-08 Harrison Kentucky 21097 6405 72
2484727 2484727 2022-05-08 Harrison Mississippi 28047 53760 665
2484827 2484827 2022-05-08 Harrison Missouri 29081 1869 33
2485388 2485388 2022-05-08 Harrison Ohio 39067 3252 74
2486019 2486019 2022-05-08 Harrison Texas 48203 13349 227
2486410 2486410 2022-05-08 Harrison West Virginia 54033 19947 253
2480763 2480763 2022-05-07 Harrison Indiana 18061 10851 138
2480868 2480868 2022-05-07 Harrison Iowa 19085 3435 95
2481080 2481080 2022-05-07 Harrison Kentucky 21097 6405 72
2481469 2481469 2022-05-07 Harrison Mississippi 28047 53760 665
2481569 2481569 2022-05-07 Harrison Missouri 29081 1869 33
2482130 2482130 2022-05-07 Harrison Ohio 39067 3252 74
2482761 2482761 2022-05-07 Harrison Texas 48203 13347 227
2483152 2483152 2022-05-07 Harrison West Virginia 54033 19947 253
2477505 2477505 2022-05-06 Harrison Indiana 18061 10851 138
2477610 2477610 2022-05-06 Harrison Iowa 19085 3435 95
2477822 2477822 2022-05-06 Harrison Kentucky 21097 6405 72
2478211 2478211 2022-05-06 Harrison Mississippi 28047 53760 665
2478311 2478311 2022-05-06 Harrison Missouri 29081 1869 33
2478872 2478872 2022-05-06 Harrison Ohio 39067 3252 74
2479503 2479503 2022-05-06 Harrison Texas 48203 13347 227
2479894 2479894 2022-05-06 Harrison West Virginia 54033 19947 253
2474247 2474247 2022-05-05 Harrison Indiana 18061 10851 138
2474352 2474352 2022-05-05 Harrison Iowa 19085 3435 95
2474564 2474564 2022-05-05 Harrison Kentucky 21097 6405 72
2474953 2474953 2022-05-05 Harrison Mississippi 28047 53760 665
2475053 2475053 2022-05-05 Harrison Missouri 29081 1846 33
2475614 2475614 2022-05-05 Harrison Ohio 39067 3252 74
2476245 2476245 2022-05-05 Harrison Texas 48203 13345 227
2476636 2476636 2022-05-05 Harrison West Virginia 54033 19940 253
2470990 2470990 2022-05-04 Harrison Indiana 18061 10851 138
2471095 2471095 2022-05-04 Harrison Iowa 19085 3435 95
2471307 2471307 2022-05-04 Harrison Kentucky 21097 6405 72
2471696 2471696 2022-05-04 Harrison Mississippi 28047 53760 665
2471796 2471796 2022-05-04 Harrison Missouri 29081 1821 33
2472357 2472357 2022-05-04 Harrison Ohio 39067 3241 74
2472988 2472988 2022-05-04 Harrison Texas 48203 13340 227
2473378 2473378 2022-05-04 Harrison West Virginia 54033 19925 253
2467734 2467734 2022-05-03 Harrison Indiana 18061 10843 138
2467839 2467839 2022-05-03 Harrison Iowa 19085 3435 95
2468051 2468051 2022-05-03 Harrison Kentucky 21097 6405 72
2468440 2468440 2022-05-03 Harrison Mississippi 28047 53760 665
2468540 2468540 2022-05-03 Harrison Missouri 29081 1821 33
2469101 2469101 2022-05-03 Harrison Ohio 39067 3241 74
2469732 2469732 2022-05-03 Harrison Texas 48203 13339 227
2470121 2470121 2022-05-03 Harrison West Virginia 54033 19916 253
2464479 2464479 2022-05-02 Harrison Indiana 18061 10843 138
2464584 2464584 2022-05-02 Harrison Iowa 19085 3435 95
2464796 2464796 2022-05-02 Harrison Kentucky 21097 6405 72
2465185 2465185 2022-05-02 Harrison Mississippi 28047 53760 665
2465284 2465284 2022-05-02 Harrison Missouri 29081 1821 33
2465845 2465845 2022-05-02 Harrison Ohio 39067 3241 74
2466476 2466476 2022-05-02 Harrison Texas 48203 13339 227
2466865 2466865 2022-05-02 Harrison West Virginia 54033 19907 251
2461223 2461223 2022-05-01 Harrison Indiana 18061 10839 138
2461328 2461328 2022-05-01 Harrison Iowa 19085 3435 95
2461540 2461540 2022-05-01 Harrison Kentucky 21097 6396 70
2461929 2461929 2022-05-01 Harrison Mississippi 28047 53702 664

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