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

5,432 rows where county = "Richland" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 7

fips 7

county 1

  • Richland · 5,432 ✖
Link rowid date ▲ county state fips cases deaths
2500256 2500256 2022-05-13 Richland Illinois 17159 5167 83
2500740 2500740 2022-05-13 Richland Louisiana 22083 6732 97
2501234 2501234 2022-05-13 Richland Montana 30083 2646 35
2501624 2501624 2022-05-13 Richland North Dakota 38077 4108 23
2501713 2501713 2022-05-13 Richland Ohio 39139 31806 508
2502038 2502038 2022-05-13 Richland South Carolina 45079 123578 947
2502790 2502790 2022-05-13 Richland Wisconsin 55103 3995 48
2496998 2496998 2022-05-12 Richland Illinois 17159 5167 83
2497482 2497482 2022-05-12 Richland Louisiana 22083 6730 97
2497976 2497976 2022-05-12 Richland Montana 30083 2645 33
2498366 2498366 2022-05-12 Richland North Dakota 38077 4100 23
2498455 2498455 2022-05-12 Richland Ohio 39139 31806 508
2498780 2498780 2022-05-12 Richland South Carolina 45079 123578 947
2499532 2499532 2022-05-12 Richland Wisconsin 55103 3988 48
2493740 2493740 2022-05-11 Richland Illinois 17159 5166 83
2494224 2494224 2022-05-11 Richland Louisiana 22083 6729 97
2494718 2494718 2022-05-11 Richland Montana 30083 2645 33
2495108 2495108 2022-05-11 Richland North Dakota 38077 4100 23
2495197 2495197 2022-05-11 Richland Ohio 39139 31699 507
2495522 2495522 2022-05-11 Richland South Carolina 45079 123578 947
2496274 2496274 2022-05-11 Richland Wisconsin 55103 3976 48
2490482 2490482 2022-05-10 Richland Illinois 17159 5165 83
2490966 2490966 2022-05-10 Richland Louisiana 22083 6729 97
2491460 2491460 2022-05-10 Richland Montana 30083 2645 33
2491850 2491850 2022-05-10 Richland North Dakota 38077 4100 23
2491939 2491939 2022-05-10 Richland Ohio 39139 31699 507
2492264 2492264 2022-05-10 Richland South Carolina 45079 123033 947
2493016 2493016 2022-05-10 Richland Wisconsin 55103 3969 48
2487225 2487225 2022-05-09 Richland Illinois 17159 5164 83
2487709 2487709 2022-05-09 Richland Louisiana 22083 6727 97
2488202 2488202 2022-05-09 Richland Montana 30083 2645 33
2488592 2488592 2022-05-09 Richland North Dakota 38077 4100 23
2488681 2488681 2022-05-09 Richland Ohio 39139 31699 507
2489006 2489006 2022-05-09 Richland South Carolina 45079 123033 947
2489758 2489758 2022-05-09 Richland Wisconsin 55103 3965 48
2483967 2483967 2022-05-08 Richland Illinois 17159 5164 83
2484451 2484451 2022-05-08 Richland Louisiana 22083 6725 97
2484945 2484945 2022-05-08 Richland Montana 30083 2645 33
2485335 2485335 2022-05-08 Richland North Dakota 38077 4100 23
2485424 2485424 2022-05-08 Richland Ohio 39139 31699 507
2485749 2485749 2022-05-08 Richland South Carolina 45079 123033 947
2486501 2486501 2022-05-08 Richland Wisconsin 55103 3957 48
2480709 2480709 2022-05-07 Richland Illinois 17159 5164 83
2481193 2481193 2022-05-07 Richland Louisiana 22083 6725 97
2481687 2481687 2022-05-07 Richland Montana 30083 2645 33
2482077 2482077 2022-05-07 Richland North Dakota 38077 4100 23
2482166 2482166 2022-05-07 Richland Ohio 39139 31699 507
2482491 2482491 2022-05-07 Richland South Carolina 45079 123033 947
2483243 2483243 2022-05-07 Richland Wisconsin 55103 3957 48
2477451 2477451 2022-05-06 Richland Illinois 17159 5164 83
2477935 2477935 2022-05-06 Richland Louisiana 22083 6725 97
2478429 2478429 2022-05-06 Richland Montana 30083 2645 33
2478819 2478819 2022-05-06 Richland North Dakota 38077 4100 23
2478908 2478908 2022-05-06 Richland Ohio 39139 31699 507
2479233 2479233 2022-05-06 Richland South Carolina 45079 123033 947
2479985 2479985 2022-05-06 Richland Wisconsin 55103 3957 48
2474193 2474193 2022-05-05 Richland Illinois 17159 5164 83
2474677 2474677 2022-05-05 Richland Louisiana 22083 6725 97
2475171 2475171 2022-05-05 Richland Montana 30083 2644 33
2475561 2475561 2022-05-05 Richland North Dakota 38077 4089 23
2475650 2475650 2022-05-05 Richland Ohio 39139 31699 507
2475975 2475975 2022-05-05 Richland South Carolina 45079 123033 947
2476727 2476727 2022-05-05 Richland Wisconsin 55103 3951 48
2470936 2470936 2022-05-04 Richland Illinois 17159 5163 83
2471420 2471420 2022-05-04 Richland Louisiana 22083 6725 97
2471914 2471914 2022-05-04 Richland Montana 30083 2643 33
2472304 2472304 2022-05-04 Richland North Dakota 38077 4089 23
2472393 2472393 2022-05-04 Richland Ohio 39139 31646 507
2472718 2472718 2022-05-04 Richland South Carolina 45079 123033 947
2473469 2473469 2022-05-04 Richland Wisconsin 55103 3949 48
2467680 2467680 2022-05-03 Richland Illinois 17159 5162 83
2468164 2468164 2022-05-03 Richland Louisiana 22083 6725 97
2468658 2468658 2022-05-03 Richland Montana 30083 2643 33
2469048 2469048 2022-05-03 Richland North Dakota 38077 4089 23
2469137 2469137 2022-05-03 Richland Ohio 39139 31646 507
2469462 2469462 2022-05-03 Richland South Carolina 45079 123033 947
2470212 2470212 2022-05-03 Richland Wisconsin 55103 3937 48
2464425 2464425 2022-05-02 Richland Illinois 17159 5162 83
2464909 2464909 2022-05-02 Richland Louisiana 22083 6723 97
2465402 2465402 2022-05-02 Richland Montana 30083 2642 33
2465792 2465792 2022-05-02 Richland North Dakota 38077 4089 23
2465881 2465881 2022-05-02 Richland Ohio 39139 31646 507
2466206 2466206 2022-05-02 Richland South Carolina 45079 122652 943
2466956 2466956 2022-05-02 Richland Wisconsin 55103 3935 48
2461169 2461169 2022-05-01 Richland Illinois 17159 5162 83
2461653 2461653 2022-05-01 Richland Louisiana 22083 6721 97
2462147 2462147 2022-05-01 Richland Montana 30083 2642 33
2462537 2462537 2022-05-01 Richland North Dakota 38077 4089 23
2462626 2462626 2022-05-01 Richland Ohio 39139 31646 507
2462951 2462951 2022-05-01 Richland South Carolina 45079 122652 943
2463701 2463701 2022-05-01 Richland Wisconsin 55103 3921 48
2457913 2457913 2022-04-30 Richland Illinois 17159 5162 83
2458397 2458397 2022-04-30 Richland Louisiana 22083 6721 97
2458891 2458891 2022-04-30 Richland Montana 30083 2642 33
2459281 2459281 2022-04-30 Richland North Dakota 38077 4089 23
2459370 2459370 2022-04-30 Richland Ohio 39139 31646 507
2459695 2459695 2022-04-30 Richland South Carolina 45079 122652 943
2460445 2460445 2022-04-30 Richland Wisconsin 55103 3921 48
2454657 2454657 2022-04-29 Richland Illinois 17159 5162 83
2455141 2455141 2022-04-29 Richland Louisiana 22083 6721 97

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