ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Richland" and state = "Louisiana" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8710 | 8710 | 2020-03-23 | Richland | Louisiana | 22083 | 1 | 0 |
9998 | 9998 | 2020-03-24 | Richland | Louisiana | 22083 | 1 | 0 |
11405 | 11405 | 2020-03-25 | Richland | Louisiana | 22083 | 1 | 0 |
12984 | 12984 | 2020-03-26 | Richland | Louisiana | 22083 | 1 | 0 |
14691 | 14691 | 2020-03-27 | Richland | Louisiana | 22083 | 2 | 0 |
16511 | 16511 | 2020-03-28 | Richland | Louisiana | 22083 | 2 | 0 |
18424 | 18424 | 2020-03-29 | Richland | Louisiana | 22083 | 2 | 0 |
20440 | 20440 | 2020-03-30 | Richland | Louisiana | 22083 | 2 | 0 |
22548 | 22548 | 2020-03-31 | Richland | Louisiana | 22083 | 2 | 0 |
24724 | 24724 | 2020-04-01 | Richland | Louisiana | 22083 | 3 | 0 |
26975 | 26975 | 2020-04-02 | Richland | Louisiana | 22083 | 4 | 0 |
29292 | 29292 | 2020-04-03 | Richland | Louisiana | 22083 | 4 | 0 |
31670 | 31670 | 2020-04-04 | Richland | Louisiana | 22083 | 9 | 0 |
34095 | 34095 | 2020-04-05 | Richland | Louisiana | 22083 | 10 | 0 |
36553 | 36553 | 2020-04-06 | Richland | Louisiana | 22083 | 11 | 0 |
39061 | 39061 | 2020-04-07 | Richland | Louisiana | 22083 | 13 | 0 |
41613 | 41613 | 2020-04-08 | Richland | Louisiana | 22083 | 13 | 0 |
44189 | 44189 | 2020-04-09 | Richland | Louisiana | 22083 | 16 | 0 |
46797 | 46797 | 2020-04-10 | Richland | Louisiana | 22083 | 18 | 0 |
49438 | 49438 | 2020-04-11 | Richland | Louisiana | 22083 | 19 | 0 |
52108 | 52108 | 2020-04-12 | Richland | Louisiana | 22083 | 19 | 0 |
54789 | 54789 | 2020-04-13 | Richland | Louisiana | 22083 | 20 | 0 |
57487 | 57487 | 2020-04-14 | Richland | Louisiana | 22083 | 20 | 0 |
60195 | 60195 | 2020-04-15 | Richland | Louisiana | 22083 | 21 | 0 |
62916 | 62916 | 2020-04-16 | Richland | Louisiana | 22083 | 22 | 0 |
65655 | 65655 | 2020-04-17 | Richland | Louisiana | 22083 | 27 | 0 |
68404 | 68404 | 2020-04-18 | Richland | Louisiana | 22083 | 27 | 0 |
71167 | 71167 | 2020-04-19 | Richland | Louisiana | 22083 | 33 | 0 |
73939 | 73939 | 2020-04-20 | Richland | Louisiana | 22083 | 34 | 0 |
76719 | 76719 | 2020-04-21 | Richland | Louisiana | 22083 | 38 | 0 |
79505 | 79505 | 2020-04-22 | Richland | Louisiana | 22083 | 42 | 0 |
82301 | 82301 | 2020-04-23 | Richland | Louisiana | 22083 | 45 | 0 |
85105 | 85105 | 2020-04-24 | Richland | Louisiana | 22083 | 47 | 0 |
87914 | 87914 | 2020-04-25 | Richland | Louisiana | 22083 | 48 | 0 |
90730 | 90730 | 2020-04-26 | Richland | Louisiana | 22083 | 48 | 0 |
93551 | 93551 | 2020-04-27 | Richland | Louisiana | 22083 | 52 | 0 |
96386 | 96386 | 2020-04-28 | Richland | Louisiana | 22083 | 53 | 0 |
99232 | 99232 | 2020-04-29 | Richland | Louisiana | 22083 | 56 | 0 |
102084 | 102084 | 2020-04-30 | Richland | Louisiana | 22083 | 58 | 0 |
104945 | 104945 | 2020-05-01 | Richland | Louisiana | 22083 | 66 | 0 |
107809 | 107809 | 2020-05-02 | Richland | Louisiana | 22083 | 73 | 0 |
110681 | 110681 | 2020-05-03 | Richland | Louisiana | 22083 | 74 | 0 |
113558 | 113558 | 2020-05-04 | Richland | Louisiana | 22083 | 82 | 0 |
116440 | 116440 | 2020-05-05 | Richland | Louisiana | 22083 | 84 | 1 |
119401 | 119401 | 2020-05-06 | Richland | Louisiana | 22083 | 86 | 1 |
122372 | 122372 | 2020-05-07 | Richland | Louisiana | 22083 | 91 | 1 |
125354 | 125354 | 2020-05-08 | Richland | Louisiana | 22083 | 95 | 1 |
128341 | 128341 | 2020-05-09 | Richland | Louisiana | 22083 | 99 | 1 |
131331 | 131331 | 2020-05-10 | Richland | Louisiana | 22083 | 100 | 1 |
134322 | 134322 | 2020-05-11 | Richland | Louisiana | 22083 | 103 | 1 |
137312 | 137312 | 2020-05-12 | Richland | Louisiana | 22083 | 103 | 1 |
140306 | 140306 | 2020-05-13 | Richland | Louisiana | 22083 | 104 | 1 |
143301 | 143301 | 2020-05-14 | Richland | Louisiana | 22083 | 104 | 1 |
146301 | 146301 | 2020-05-15 | Richland | Louisiana | 22083 | 106 | 1 |
149306 | 149306 | 2020-05-16 | Richland | Louisiana | 22083 | 106 | 1 |
152317 | 152317 | 2020-05-17 | Richland | Louisiana | 22083 | 106 | 1 |
155331 | 155331 | 2020-05-18 | Richland | Louisiana | 22083 | 107 | 1 |
158349 | 158349 | 2020-05-19 | Richland | Louisiana | 22083 | 108 | 2 |
161375 | 161375 | 2020-05-20 | Richland | Louisiana | 22083 | 108 | 2 |
164404 | 164404 | 2020-05-21 | Richland | Louisiana | 22083 | 113 | 2 |
167440 | 167440 | 2020-05-22 | Richland | Louisiana | 22083 | 114 | 2 |
170478 | 170478 | 2020-05-23 | Richland | Louisiana | 22083 | 114 | 3 |
173519 | 173519 | 2020-05-24 | Richland | Louisiana | 22083 | 114 | 3 |
176563 | 176563 | 2020-05-25 | Richland | Louisiana | 22083 | 119 | 3 |
179607 | 179607 | 2020-05-26 | Richland | Louisiana | 22083 | 119 | 3 |
182652 | 182652 | 2020-05-27 | Richland | Louisiana | 22083 | 124 | 3 |
185707 | 185707 | 2020-05-28 | Richland | Louisiana | 22083 | 125 | 3 |
188765 | 188765 | 2020-05-29 | Richland | Louisiana | 22083 | 125 | 3 |
191829 | 191829 | 2020-05-30 | Richland | Louisiana | 22083 | 128 | 3 |
194897 | 194897 | 2020-05-31 | Richland | Louisiana | 22083 | 135 | 3 |
197968 | 197968 | 2020-06-01 | Richland | Louisiana | 22083 | 138 | 3 |
201040 | 201040 | 2020-06-02 | Richland | Louisiana | 22083 | 139 | 3 |
204117 | 204117 | 2020-06-03 | Richland | Louisiana | 22083 | 143 | 3 |
207198 | 207198 | 2020-06-04 | Richland | Louisiana | 22083 | 148 | 3 |
210279 | 210279 | 2020-06-05 | Richland | Louisiana | 22083 | 148 | 3 |
213364 | 213364 | 2020-06-06 | Richland | Louisiana | 22083 | 149 | 3 |
216451 | 216451 | 2020-06-07 | Richland | Louisiana | 22083 | 153 | 3 |
219543 | 219543 | 2020-06-08 | Richland | Louisiana | 22083 | 156 | 3 |
222638 | 222638 | 2020-06-09 | Richland | Louisiana | 22083 | 157 | 3 |
225734 | 225734 | 2020-06-10 | Richland | Louisiana | 22083 | 157 | 3 |
228836 | 228836 | 2020-06-11 | Richland | Louisiana | 22083 | 159 | 3 |
231940 | 231940 | 2020-06-12 | Richland | Louisiana | 22083 | 160 | 3 |
235045 | 235045 | 2020-06-13 | Richland | Louisiana | 22083 | 163 | 3 |
238152 | 238152 | 2020-06-14 | Richland | Louisiana | 22083 | 163 | 3 |
241261 | 241261 | 2020-06-15 | Richland | Louisiana | 22083 | 164 | 3 |
244372 | 244372 | 2020-06-16 | Richland | Louisiana | 22083 | 164 | 3 |
247485 | 247485 | 2020-06-17 | Richland | Louisiana | 22083 | 167 | 3 |
250597 | 250597 | 2020-06-18 | Richland | Louisiana | 22083 | 167 | 3 |
253712 | 253712 | 2020-06-19 | Richland | Louisiana | 22083 | 144 | 3 |
256832 | 256832 | 2020-06-20 | Richland | Louisiana | 22083 | 148 | 3 |
259958 | 259958 | 2020-06-21 | Richland | Louisiana | 22083 | 148 | 3 |
263087 | 263087 | 2020-06-22 | Richland | Louisiana | 22083 | 150 | 3 |
266214 | 266214 | 2020-06-23 | Richland | Louisiana | 22083 | 152 | 4 |
269347 | 269347 | 2020-06-24 | Richland | Louisiana | 22083 | 155 | 4 |
272483 | 272483 | 2020-06-25 | Richland | Louisiana | 22083 | 160 | 4 |
275626 | 275626 | 2020-06-26 | Richland | Louisiana | 22083 | 168 | 4 |
278774 | 278774 | 2020-06-27 | Richland | Louisiana | 22083 | 168 | 4 |
281922 | 281922 | 2020-06-28 | Richland | Louisiana | 22083 | 175 | 4 |
285068 | 285068 | 2020-06-29 | Richland | Louisiana | 22083 | 183 | 4 |
288217 | 288217 | 2020-06-30 | Richland | Louisiana | 22083 | 188 | 4 |
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);