ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
5,432 rows where county = "Richland" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 7
- South Carolina 788
- Ohio 786
- Louisiana 782
- Wisconsin 778
- Illinois 767
- Montana 766
- North Dakota 765
county 1
- Richland · 5,432 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3650 | 3650 | 2020-03-17 | Richland | South Carolina | 45079 | 1 | 0 |
4270 | 4270 | 2020-03-18 | Richland | South Carolina | 45079 | 4 | 0 |
4945 | 4945 | 2020-03-19 | Richland | Ohio | 39139 | 1 | 0 |
5014 | 5014 | 2020-03-19 | Richland | South Carolina | 45079 | 8 | 0 |
5809 | 5809 | 2020-03-20 | Richland | Ohio | 39139 | 1 | 0 |
5894 | 5894 | 2020-03-20 | Richland | South Carolina | 45079 | 22 | 0 |
6810 | 6810 | 2020-03-21 | Richland | Ohio | 39139 | 1 | 0 |
6904 | 6904 | 2020-03-21 | Richland | South Carolina | 45079 | 28 | 0 |
7922 | 7922 | 2020-03-22 | Richland | Ohio | 39139 | 1 | 0 |
8025 | 8025 | 2020-03-22 | Richland | South Carolina | 45079 | 31 | 0 |
8710 | 8710 | 2020-03-23 | Richland | Louisiana | 22083 | 1 | 0 |
9128 | 9128 | 2020-03-23 | Richland | Ohio | 39139 | 1 | 0 |
9239 | 9239 | 2020-03-23 | Richland | South Carolina | 45079 | 43 | 0 |
9998 | 9998 | 2020-03-24 | Richland | Louisiana | 22083 | 1 | 0 |
10444 | 10444 | 2020-03-24 | Richland | Ohio | 39139 | 4 | 0 |
10565 | 10565 | 2020-03-24 | Richland | South Carolina | 45079 | 45 | 0 |
11405 | 11405 | 2020-03-25 | Richland | Louisiana | 22083 | 1 | 0 |
11895 | 11895 | 2020-03-25 | Richland | Ohio | 39139 | 4 | 0 |
12037 | 12037 | 2020-03-25 | Richland | South Carolina | 45079 | 59 | 0 |
12984 | 12984 | 2020-03-26 | Richland | Louisiana | 22083 | 1 | 0 |
13504 | 13504 | 2020-03-26 | Richland | Ohio | 39139 | 4 | 0 |
13659 | 13659 | 2020-03-26 | Richland | South Carolina | 45079 | 60 | 0 |
14691 | 14691 | 2020-03-27 | Richland | Louisiana | 22083 | 2 | 0 |
15242 | 15242 | 2020-03-27 | Richland | Ohio | 39139 | 4 | 0 |
15406 | 15406 | 2020-03-27 | Richland | South Carolina | 45079 | 65 | 1 |
15778 | 15778 | 2020-03-27 | Richland | Wisconsin | 55103 | 2 | 0 |
16511 | 16511 | 2020-03-28 | Richland | Louisiana | 22083 | 2 | 0 |
17086 | 17086 | 2020-03-28 | Richland | Ohio | 39139 | 5 | 0 |
17261 | 17261 | 2020-03-28 | Richland | South Carolina | 45079 | 81 | 2 |
17659 | 17659 | 2020-03-28 | Richland | Wisconsin | 55103 | 2 | 0 |
18424 | 18424 | 2020-03-29 | Richland | Louisiana | 22083 | 2 | 0 |
19020 | 19020 | 2020-03-29 | Richland | Ohio | 39139 | 5 | 0 |
19201 | 19201 | 2020-03-29 | Richland | South Carolina | 45079 | 98 | 2 |
19628 | 19628 | 2020-03-29 | Richland | Wisconsin | 55103 | 2 | 0 |
20440 | 20440 | 2020-03-30 | Richland | Louisiana | 22083 | 2 | 0 |
21066 | 21066 | 2020-03-30 | Richland | Ohio | 39139 | 5 | 0 |
21253 | 21253 | 2020-03-30 | Richland | South Carolina | 45079 | 135 | 2 |
21700 | 21700 | 2020-03-30 | Richland | Wisconsin | 55103 | 2 | 0 |
22548 | 22548 | 2020-03-31 | Richland | Louisiana | 22083 | 2 | 0 |
23199 | 23199 | 2020-03-31 | Richland | Ohio | 39139 | 6 | 0 |
23391 | 23391 | 2020-03-31 | Richland | South Carolina | 45079 | 148 | 2 |
23853 | 23853 | 2020-03-31 | Richland | Wisconsin | 55103 | 2 | 0 |
24724 | 24724 | 2020-04-01 | Richland | Louisiana | 22083 | 3 | 0 |
25395 | 25395 | 2020-04-01 | Richland | Ohio | 39139 | 8 | 0 |
25589 | 25589 | 2020-04-01 | Richland | South Carolina | 45079 | 176 | 3 |
26074 | 26074 | 2020-04-01 | Richland | Wisconsin | 55103 | 2 | 0 |
26975 | 26975 | 2020-04-02 | Richland | Louisiana | 22083 | 4 | 0 |
27663 | 27663 | 2020-04-02 | Richland | Ohio | 39139 | 8 | 0 |
27865 | 27865 | 2020-04-02 | Richland | South Carolina | 45079 | 200 | 3 |
28367 | 28367 | 2020-04-02 | Richland | Wisconsin | 55103 | 2 | 0 |
29292 | 29292 | 2020-04-03 | Richland | Louisiana | 22083 | 4 | 0 |
29992 | 29992 | 2020-04-03 | Richland | Ohio | 39139 | 10 | 0 |
30200 | 30200 | 2020-04-03 | Richland | South Carolina | 45079 | 224 | 5 |
30722 | 30722 | 2020-04-03 | Richland | Wisconsin | 55103 | 2 | 0 |
31670 | 31670 | 2020-04-04 | Richland | Louisiana | 22083 | 9 | 0 |
32381 | 32381 | 2020-04-04 | Richland | Ohio | 39139 | 14 | 0 |
32591 | 32591 | 2020-04-04 | Richland | South Carolina | 45079 | 242 | 6 |
33124 | 33124 | 2020-04-04 | Richland | Wisconsin | 55103 | 3 | 0 |
34095 | 34095 | 2020-04-05 | Richland | Louisiana | 22083 | 10 | 0 |
34815 | 34815 | 2020-04-05 | Richland | Ohio | 39139 | 17 | 0 |
35027 | 35027 | 2020-04-05 | Richland | South Carolina | 45079 | 298 | 6 |
35563 | 35563 | 2020-04-05 | Richland | Wisconsin | 55103 | 3 | 0 |
36553 | 36553 | 2020-04-06 | Richland | Louisiana | 22083 | 11 | 0 |
37287 | 37287 | 2020-04-06 | Richland | Ohio | 39139 | 19 | 0 |
37502 | 37502 | 2020-04-06 | Richland | South Carolina | 45079 | 311 | 7 |
38050 | 38050 | 2020-04-06 | Richland | Wisconsin | 55103 | 3 | 0 |
38688 | 38688 | 2020-04-07 | Richland | Illinois | 17159 | 1 | 0 |
39061 | 39061 | 2020-04-07 | Richland | Louisiana | 22083 | 13 | 0 |
39805 | 39805 | 2020-04-07 | Richland | Ohio | 39139 | 20 | 0 |
40025 | 40025 | 2020-04-07 | Richland | South Carolina | 45079 | 340 | 7 |
40592 | 40592 | 2020-04-07 | Richland | Wisconsin | 55103 | 3 | 0 |
41233 | 41233 | 2020-04-08 | Richland | Illinois | 17159 | 1 | 0 |
41613 | 41613 | 2020-04-08 | Richland | Louisiana | 22083 | 13 | 0 |
42017 | 42017 | 2020-04-08 | Richland | Montana | 30083 | 2 | 0 |
42365 | 42365 | 2020-04-08 | Richland | Ohio | 39139 | 25 | 0 |
42585 | 42585 | 2020-04-08 | Richland | South Carolina | 45079 | 372 | 10 |
43164 | 43164 | 2020-04-08 | Richland | Wisconsin | 55103 | 3 | 0 |
43808 | 43808 | 2020-04-09 | Richland | Illinois | 17159 | 1 | 0 |
44189 | 44189 | 2020-04-09 | Richland | Louisiana | 22083 | 16 | 0 |
44596 | 44596 | 2020-04-09 | Richland | Montana | 30083 | 2 | 0 |
44875 | 44875 | 2020-04-09 | Richland | North Dakota | 38077 | 1 | 0 |
44951 | 44951 | 2020-04-09 | Richland | Ohio | 39139 | 27 | 1 |
45171 | 45171 | 2020-04-09 | Richland | South Carolina | 45079 | 417 | 10 |
45761 | 45761 | 2020-04-09 | Richland | Wisconsin | 55103 | 3 | 0 |
46412 | 46412 | 2020-04-10 | Richland | Illinois | 17159 | 1 | 0 |
46797 | 46797 | 2020-04-10 | Richland | Louisiana | 22083 | 18 | 0 |
47206 | 47206 | 2020-04-10 | Richland | Montana | 30083 | 2 | 0 |
47488 | 47488 | 2020-04-10 | Richland | North Dakota | 38077 | 1 | 0 |
47566 | 47566 | 2020-04-10 | Richland | Ohio | 39139 | 28 | 1 |
47788 | 47788 | 2020-04-10 | Richland | South Carolina | 45079 | 452 | 10 |
48390 | 48390 | 2020-04-10 | Richland | Wisconsin | 55103 | 4 | 0 |
49045 | 49045 | 2020-04-11 | Richland | Illinois | 17159 | 1 | 0 |
49438 | 49438 | 2020-04-11 | Richland | Louisiana | 22083 | 19 | 0 |
49855 | 49855 | 2020-04-11 | Richland | Montana | 30083 | 3 | 0 |
50143 | 50143 | 2020-04-11 | Richland | North Dakota | 38077 | 2 | 0 |
50222 | 50222 | 2020-04-11 | Richland | Ohio | 39139 | 34 | 1 |
50445 | 50445 | 2020-04-11 | Richland | South Carolina | 45079 | 479 | 10 |
51051 | 51051 | 2020-04-11 | Richland | Wisconsin | 55103 | 5 | 0 |
51707 | 51707 | 2020-04-12 | Richland | Illinois | 17159 | 1 | 0 |
52108 | 52108 | 2020-04-12 | Richland | Louisiana | 22083 | 19 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);